VERY URGENT

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