View previous topic :: View next topic
|
Author |
Message |
erhema
New User
Joined: 07 Oct 2008 Posts: 23 Location: Chennai
|
|
|
|
Hi,
Am getting -204 with sqlstate 42704 from a prepare statemnt of a dynamic query from a subprogram that is called by a stored procedure.
The same subprogram has normal query(non dynamic) using other tables before this dynamic query and that has went successfull.
The error states that <myuserid.tablename> is an undefined object. Instead of myuserid, qualifier of the table should have be used by the program.
This subprogram is in production for a long time. And i have to pass correct qualifer to this query.
I have created a package with the owner as correct qualifier and tried, this doesnt solve the problem. I was wondering how the first query passed without any error.
Could anyone please help me in resolving this issue.
Thanks. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
erhema
New User
Joined: 07 Oct 2008 Posts: 23 Location: Chennai
|
|
|
|
Thanks, i used dynamicrules(bind) option for my package creation. Still am getting the same error(-204). |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
erhema wrote: |
Thanks, i used dynamicrules(bind) option for my package creation. Still am getting the same error(-204). |
package of subprogram or package of main program ? I would try both.
also try using set current sqlid in subprogram |
|
Back to top |
|
|
|