CREATE PROCEDURE ValidateFormat (
    IN sometable VARCHAR(255)
)
BEGIN
    DECLARE OriginalTable;

    Set OriginalTable = sometable,

    -- try and figure out what the table name should be...
    IF sometable IS NULL or sometable = '' THEN
        SET sometable = '',Concat(cast(client)),'.''v$TABLENAME$'
    ELSE IF sometable like '%.%' THEN
        SET sometable = '', concat(cast(client)),'.',sometable
    ELSE
        SET sometable = '',Concat(cast(client)),'.',sometable;
END