Home » Developer & Programmer » Forms » execute_query
execute_query [message #77822] Wed, 28 November 2001 03:15 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
Hi all,
2 questions:
a)which exception is thrown when "execute_query" returns no matches...the no_data_found exception doesn't work.
b)how can i get the number of returned records
thanx in advance

----------------------------------------------------------------------
Re: execute_query [message #77823 is a reply to message #77822] Wed, 28 November 2001 04:11 Go to previous message
Srinivas Konda
Messages: 29
Registered: October 2001
Junior Member
1. You can use the following code to supress the "query caused no records to be retrived" message. I donot think it raises any exception.
:system.message_level := 5;
EXECUTE_QUERY;
:system.message_level := 0;

2. You can get the no. of records retuned by a execute_query by the following code.

EXECUTE_QUERY;
IF GET_BLOCK_PROPERTY('EMP',QUERY_HITS) > 0 THEN
MESSAGE('data found ');MESSAGE('data found ');
END IF;

----------------------------------------------------------------------
Previous Topic: Using HOST to print a Report from FORM
Next Topic: Oracle Repository Problem
Goto Forum:
  


Current Time: Thu Mar 28 12:02:46 CDT 2024