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'

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 20 09:01:18 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.