Click here to Skip to main content
15,880,796 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Comments
greatwhite1 19-Nov-19 10:21am    
So I created a simple procedure to try and call with no luck. This is so easy to do in Microsoft. I am actually wondering now if you can even call procedures from SQL Dev. Are there add ons I need to the oracle database to accomplish this.

create or replace procedure My_login( IN_User_id number,out_p out varchar2)
is
begin
select app_users.user_name into out_p from app_users where user_id =IN_User_id;
end My_login;


--Call to procedure
set serveroutput on;
Declare
Answer varchar2(100);
begin

My_login(1976, :Answer);
dbms_output.putline(Answer);

End;
greatwhite1 25-Nov-19 9:21am    
Thanks
Jörgen Andersson 24-Nov-19 14:08pm    
This is old, but the principles are still the same: https://developer.oracle.com/dotnet/williams-sps.html

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900