|
Respected Sir
This is srinvas.
I have been working with Postgresql and have
created tables,constraints and so on.
Now i am writing stored functions using refcursor
and the stored function have created successfully. But i have problem to
validate the parameters passed in the call function..
The query in function returns all the rows with the
following statement.
open refcursor for 'select
statement'; // without parameters validation
Now i want to validate the parameters and add those
validations to the above select query to restrict the output when the
parameter is not null.
Example:
if parameter1 is not null then
sqlstring := sqlstring || ' where
num=1';
else
sqlstring:= ' ';
end if
open refcursor for ' select statement ' ||
sqlstring; // Query should be .... select * from
table_name where num=1;
When i used the above statements and execute the
function it's not returning the data even the parameter validation is true(num=1
is existing).
Please help on above issues and also let me know
how to diplay string values (sqlstring).
Example :-(in oracle)
dbms_output.put_line(sqlstring);
I would be very greatful if you could accelerate
your reply.
Thank you
Best Regards
Srinivas
|
