I have a package called app_user_api with a function in it called:
Procedure login(
p_username varchar2,
p_password varchar2,
p_XMLdata out clob,
p_binary varchar2 default null);
I am baffled as to how to call this everything I try does not work.
Can this be run from SQL Developer or is there a way I could at least call it from a Visual Studio application?
What I have tried:
begin
declare c clob
APP_USER_API.login('test','test',:c,null);
print c
end