OraFAQ Forum: Forms » using cursor with procedure

Home » Developer & Programmer » Forms » using cursor with procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

using cursor with procedure [message #219618]

Thu, 15 February 2007 03:22

wreyaz
Messages: 44
Registered: April 2006
Location: Saudi Arabia

Member

Can any one of you help me to solve this problem:
I just build one sample application to generate payroll & it is working fine. In that application i have one form with four text items to pass parameters (:month, :year, :eno1 & :eno2), one display icon (:sts) to display the status & one push button (to generate payroll).

Now, i want to use Stored procedure instead of writing the coding on when-Button-Pressed trigger.
I want to create this procedure in the database so that i can call this procedure in the application to get the result.

I tried a lot to create procedure my self but i stuck at the cursor. I did not know how to use use the cursor with the procedure.

The code which i am using to generate the payroll is herewith attached.

Can any one help me to build the required cursor & precedure & send back to me on reyazw@hotmail.com.

regards.