var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have to execute a pl/sql function. The function is returning a ref cursor. But the function name will be known only at the runtime i.e. i have to execute using dynamic sql. The dynamic sql string will be like following.........
vc_str:='begin ' ||
':x :=' || variable_containing_function_name || ';' ||
What i want to do is execute the function and get thereturn value in host variable x.
The function is returning ref cursor. So i am not able to use dbms_sql. Since dbms_sql.bind_variable can not bind a ref cursor.
Any idea how to achieve this.
You can so this with NDS instead of DBMS_SQL:
execute immediate vc_str using out v_rc;
where v_rc is a ref cursor variable.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors