| Executing Package Procedure from Oracle forms [message #329726] |
Thu, 26 June 2008 06:15  |
jramya
Messages: 42
Registered: April 2008
|
Member |
|
|
HI All,
I am searching on this stuff for the past two days.
How do I execute a database package.procedure from a form?
I am just trying to execute the procedure with no return values.
I am able to execute the below successfully
BEGIN
pkg_renewal.TEST1('01-JAN-2006','30-JAN-2006');
END;
in Toad but not in Forms.
Can anybody help me with some link or clue on how to execute .
Thank you
[Updated on: Thu, 26 June 2008 06:27] Report message to a moderator |
|
|
|
| Re: Executing Package Procedure from Oracle forms [message #329744 is a reply to message #329726] |
Thu, 26 June 2008 07:17  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why not? What prevents you to do that? Is there any error message? If so, which one?
Besides, it seems that your procedure uses DATE datatype parameters. Does it? If so, why are you using STRINGS instead? '01-JAN-2006' *looks like* a date to you and me, but - as far as Oracle is concerned - it is just a string, NOT a date.
Therefore, perhaps you'd want to use proper datatype casting and use a proper syntax:BEGIN
pkg_renewal.TEST1(to_date('01-JAN-2006', 'dd-mon-yyyy'),
to_date('30-JAN-2006', 'dd-mon-yyyy')
);
END;
Now try again; if it still doesn't work, provide valid information. "It doesn't work" means nothing.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
