Re: How to pass parameteres from PC Forms4.5 to stored functions in the server databse

Ko Ho Yuen <tomas_at_cs.ust.hk> wrote in article <56ht04$o0h_at_ustsu10.ust.hk>...
> Vahid A. Tadjkarimi (vahidt_at_ibm530.vitek.com) wrote:
> : Are you aware of a way to pass parameters from Windows3.1 FORM4.5 to
> : to stored functions in the server Oracle database? Any hints will be
> : appreciated.
> Just call the function as any other ordinary functions.
> e.g. output := SchemaA.funcA (p1, p2)
>
> tomas
>

Basically all you need to do is calling the function with its arguments listede one after another in the call: <stored_function>(argument1, argument2).

The reason with you ask this question might be that you have actually tried this and received an error. When you declare the function in the package body, you have to add the following line:

pragma restrict_references(<stored_function>, WNDS)

By this way you are telling Oracle that your function does not contain any DML statements. The reason for this is that you can use your function as an argument in a select clause - so the result of the query might be inconsistent if the function forexample tries to modifiy the table you select from.

Emil Received on Thu Nov 28 1996 - 00:00:00 CST