Home » Developer & Programmer » Forms » fetching value from a dynamic query in forms10g
fetching value from a dynamic query in forms10g [message #348666] Wed, 17 September 2008 09:17 Go to next message
menaxi20
Messages: 1
Registered: September 2008
Junior Member
vSqlStmt := 'SELECT count(pp.PATIENT_POSITION_ID) into vcount ' || vFromStmt || vWhereStmt ;
How to execute this statement and
Will this statement fetch the value into vcount..
I tried to execute using these
dbms_sql.parse(c, vSqlStmt, 1);
n := dbms_sql.execute(c);

In the application it says as 'missing keyword'
Re: fetching value from a dynamic query in forms10g [message #348794 is a reply to message #348666] Wed, 17 September 2008 23:49 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Post the REAL code (between 'code' tags) not just bits and pieces.

Use 'message;pause;' pairs to determine EXACTLY which line is failing.

Display the full statement on the screen before doing the 'parse' so you KNOW what is being passed to the parser.

David
Previous Topic: ORA-04067 when calling fmx
Next Topic: copy_region question
Goto Forum:
  


Current Time: Fri Dec 09 05:44:08 CST 2016

Total time taken to generate the page: 0.06630 seconds