Re: PL/SQL in FORMS won't understand ROWTYPE in procedure parameter

> tim_at_van.oz.au (Tim Nguyen) writes:
> I am using Forms 4.5 on Win3.11 and need to call a server
> stored proc , passing a record (declared as a ROWTYPE attribute
> , eg. cust_rec customer%ROWTYPE) in the parameter. It's
> appear that PL/SQL in forms (ver 1.1) doesn't understand
> ROWTYPE declaration in procedure parameters.
> Is there any workaround?
> Thanks for any pointers,
> Tim
>
>
>
>
>>>>

What is meant by "doesn't understand ROWTYPE declaration in procedure parameters"? Is it you get a compilation error?

I encountered a problem while running or compiling a form module which called a stored procedure with a ROWTYPE parameter. However, the ROWTYPE reference table hasn't been granted appropriate privileges for the current user. For a stored procedure in the database, you don't need to grant privileges for any referenced table in the stored procedure/package. However, under Forms 4.5, I didn't encounter such a problem.

Try to grant the appropriate privileges for the ROWTYPE referenced table for the user.

P.S.

~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~

  ~~~ Love is never Smooth ~~ ~~~~~~~~~~~~~ ~~~~ ·R±¡§ó«D©Z³~ ~~~~~~~~~~~~~~
   ~~~~ Always Love hard and never Life smooth ~~~ °ß¦³¼ö¤Á¦a·R,Åý¥Í©R§óºëªö ~
    ~~~~~~~~ ~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~~ 
~~~~~~~~
     ~~~~ ~~~~~~~~~~~~~~~~~~~~~ ~~ ~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~ P.S. ~~~~~
                                                      ~~~~ ~~~~~~~~~~ ~~~~~~