| call package [message #119333] |
Wed, 11 May 2005 19:11  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
drear all
i've create a package with procedure and function
i want to know how to call it from forms
i traied with "packagenamee.procedure but it didn't work
|
|
|
|
| Re: call package [message #119336 is a reply to message #119333] |
Wed, 11 May 2005 21:12  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Okay. Under which user did you store the package? Under which user are you running your form? Please include the package script (brief, I hope) in your reply and the code including your call.
David
[Updated on: Wed, 11 May 2005 21:17] Report message to a moderator |
|
|
|
| Re: call package [message #119391 is a reply to message #119333] |
Thu, 12 May 2005 06:27 |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
okay it's package contain 1procedure to create directory in path passed by parameter
and 1 function to export data using utl
procedure nameed cre_dir ,function named extract_data
package named export
at when button pressed triger :
declare
v_count number;
begin
export.CRE_DIR(:GLOBAL.V_DIR);
V_COUNT :=export.extract_data('select * from bl_d_section',',','EXT_DIR','AA.TXT');
end ;
but it return error code ora-01780
the package stored in the same user where it executed from the form
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
