Schema mapping for procedures

[shyam_uthaman]

Hi All,

if I have a code in a stored procedure that says --

if :schemaName = 'ABC'

THEN

{

..

..

}

and if the schema mapping ABC --> XYZ  is maintained in the next system, will the code also port itself?

The answer logically seems to be a No since I am entering a string value into the variable. But please do confirm on this.

Thanks,

Shyam

[Former Member · Accepted solution]

Hi Shyam,

Yes you are right, unfortunately schema mapping wouldn't work in this scenario.

Instead of hard coding the value, i would suggest you to populate the value from the table "_SYS_BI"."M_SCHEMA_MAPPING"

Regards,

Deepak

[shyam_uthaman · Accepted solution]

Makes sense. Thanks.