Hello everybody
I'm working with Oracle 8.0.4. I'm having problems with dynamic SQL.
I have a package thats calls another package. Within the second package
there is Dynamic SQL code.
The Parsing, and Executing phase are okay, but when it comes to Fetching
a row
(ie. "DBMS_SQL.FETCH_ROWS(exec_cursor)" ) there is an error "ORA-01722:
invalid number".
When the package with the Dynamic SQL is called directly it works, but
not in the above case.
I have no idea what this is!! Could someone who has any idea of what is
happening please e-mail me (deepak_at_cm.co.za)
TIA
Deepak
Received on Thu Oct 28 1999 - 06:04:25 CDT
