SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

QUOTENAME

831655Feb 23 2011 — edited Feb 23 2011

hi..

i am converting a procedure for long running process from SQL server to Oracle...

whn i compiles the procedure its giving me error in the following line....

v_FROM := ' FROM ' || (COALESCE(v_Owner, 'dbo')) || '.' || QUOTENAME+(v_Table);

the error is

Error(35,63): PLS-00201: identifier 'QUOTENAME' must be declared

i guess oralce doesn't support 'QUOTENAME' keyword ...if so then what can be the replacement??

thanks....

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2011

Added on Feb 23 2011

4 comments

3,608 views