Home » Developer & Programmer » Precompilers, OCI & OCCI » Dynamic Sql with cursor?
Dynamic Sql with cursor? [message #222667] Mon, 05 March 2007 20:05 Go to next message
LAScorpion
Messages: 8
Registered: February 2007
Location: LA
Junior Member
Can anyway tell me how to use dynamic sql with cursor in Pro*c?

I want to fecth the first row from a query sql statement, but the condition might be based on 1 field or 2 fields depending on the user input.

Can I use SQL execute stmt. USING... INTO ?
or I have to use SQL BIND VARIABLE of method 4?
or anything else?

josephliu48@hotmail.com
Thanks.

Report message to a moderator

Re: Dynamic Sql with cursor? [message #222670 is a reply to message #222667] Mon, 05 March 2007 20:37 Go to previous message
LAScorpion
Messages: 8
Registered: February 2007
Location: LA
Junior Member
It generated the below sql error.
ORA-01002: fetch out of sequence

-Joseph

Report message to a moderator

Previous Topic: how to write applications using XA???
Next Topic: sqlcxt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 11:14:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.