I'm using Oracle 7.3.4. I am having problems using multiple cursors. I declare/open both cursors at the beginning of the script, and then use them as needed throughout the remainder of the application. My second cursor never seems to work. The error I recieve is: "no statement parsed." The SQL is syntactically correct and returns 21 rows when entered directly into sqlplus (under the same user
ass and sid). The first cursor works fine in the same situation. Has anyone run into similar problems? I've looked for documentation, but to no avail...
I'm using a persistent logon, but using a normal logon doesn't work either. Also, I have tried simplifying my query to "select * from table." No dice.
thanks,
Josh.
ass and sid). The first cursor works fine in the same situation. Has anyone run into similar problems? I've looked for documentation, but to no avail...I'm using a persistent logon, but using a normal logon doesn't work either. Also, I have tried simplifying my query to "select * from table." No dice.
thanks,
Josh.