Home » Developer & Programmer » Forms » Executing Package Procedure from Oracle forms (DEveloper 6i)
Executing Package Procedure from Oracle forms [message #329726] Thu, 26 June 2008 06:15 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
but not in Forms

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.
Re: Executing Package Procedure from Oracle forms [message #329746 is a reply to message #329744] Thu, 26 June 2008 07:24 Go to previous message
jramya
Messages: 42
Registered: April 2008
Member
Oh My Little Foot,
Yes its that datatype which pulled me too much...
Your code works fine.
Thank you very much.
Previous Topic: How to disable a Tab in Multi tab Canvas
Next Topic: get column sum if its records are checked
Goto Forum:
  


Current Time: Sat Dec 10 03:22:06 CST 2016

Total time taken to generate the page: 0.10013 seconds