Pl/Sql Function Body Returning Sql Query Problem
441000Apr 15 2005 — edited Jun 20 2008Why is this code:
DECLARE
q VARCHAR2(32767); -- query
BEGIN
q := someschema.somepackage.someprocedure;
RETURN q;
END;
Which is attributed to be:
SQL Query (Pl/Sql Function Body Returning Sql Query).
Is Giving me this error:
report error:
ORA-01403: no data found
'someprocedure' Returns a valid SQL Statement in a VARCHAR2 String.
Any ideas?
Regards,
Greg.