FW: Problem with DBMS_SQL - Long and probably annoying

2001-10-31 Thread Kimberly Smith
Thanks to those who replied. Of course the answer was simple but for some reason I thought the code was right in the whole quote thing. I did need to have quotes get passed in on the third and forth parameter. I plan on rewriting the code anyway as I have not found a single reason as to wh

RE: Problem with DBMS_SQL - Long and probably annoying

2001-10-31 Thread Larry Elkins
Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly > Smith > Sent: Tuesday, October 30, 2001 6:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Problem with DBMS_SQL - Long and probably annoying > > > There is a Procedure that uses D

RE: Problem with DBMS_SQL - Long and probably annoying

2001-10-31 Thread Mercadante, Thomas F
Kimberly, Look closely at the following statement - put more debug statements in this area to show the exact sql statement you are trying to parse. The SELECT portion looks fine to me - provided that all of the columns do exist in the tables you reference. My guess is that the problem is in the

RE: Problem with DBMS_SQL - Long and probably annoying

2001-10-31 Thread Kimberly Smith
The owner of the package/tables is the one actually doing the execute so permissions is not the issue in this case. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 8:13 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Kimberly, A bit of a long shot here

RE: Problem with DBMS_SQL - Long and probably annoying

2001-10-30 Thread Reardon, Bruce (CALBBAY)
Kimberly, A bit of a long shot here - Might it be permissions related? eg - does the package owner have select on all the columns that are referenced in the package? I know this isn't an appropriate long term solution, but try granting the package owner "select any table" directly and then see i

RE: Problem with DBMS_SQL - Long and probably annoying

2001-10-30 Thread Jamadagni, Rajendra
first thing I'd do is to look at line 200 through 210 from user_source to locate the problem. Also I'd put the sql statement as constructed using dbms_output 9you'll have to do multiple calls as your sql might be > 225 characters). Running this SQL in sqlplus usually solves the invalid column pro

Problem with DBMS_SQL - Long and probably annoying

2001-10-30 Thread Kimberly Smith
There is a Procedure that uses DBMS_SQL that is causing some problems. Basically I am having problems debugging it. I got it down to the parse statement but see nothing wrong. I have taken the SQL statement out of this code and ran it manually and it works so I don't understand the error. If s