Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EXECUTE IMMEDIATE problem
Message
 
 
To
20/03/2001 11:29:42
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00486871
Message ID:
00486896
Views:
9
>HI, I try to execute this:
>
>EXECUTE IMMEDIATE 'SELECT COUNT(*) INTO v_nCountRes FROM '||v_cTable
>
>Oracle gives me an exception : -905 missing keyword
>
>What is wrong ?
>
>Thank you for your help,
>Christian

The syntax from one of my Oracle ref books is:

exec sql execute immediate "select count(*) into v_CountRes from " || v_CTable;
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform