CODEWITHSUNDEEP
plsqloracle-apex
hustlinghare
hustlinghare

Reputation: 1

using pl/sql external package and getting error with declaration

I need to run a procedure in a package external to my script. The script is in an APEX page:

begin 
   idsud.segyload.loaddataset(p_dataset_id => :p40_dset, p_mode => 'INIT'); 
end;

When I try to use this I get an error saying that I must declare the "idsud.segyload" package. How to do this?

Upvotes: 0

Views: 53

Answers (1)

Drumbeg
Drumbeg

Reputation: 1944

Have you added the appropriate permissions?

e.g. GRANT EXECUTE ON idsud.segyload TO {apex_schema};

Upvotes: 2

Related Questions