Re: stored-procedure

Virinchipuram J. A. (fbap3120_at_leonis.nus.sg) wrote:

: Query 1: The front-end clerk enters the Customer ID in the Access
: form. The server has to check the Customer ID and, if he is a
: genuine customer, has to send certain data, from its tables, to the
: front-end, which it will store temporarily. Now to perform this
: I can write stored procedures at the server, which will take the
: customer Id as the parameter. Now my question, is how will the
: procedure return value? (in this case it is going to be a set of
: records). I am using pl/sql.

I would recommend your procedure to write it's output (the set of recs) to a temproray table (so your front-end form just accesses it) and marks them with a unique key. Then this procedure can simply return the key of these records in this table.
Something like this.....

    begin

       check_cust_id(cust_id,temp_key);
       if temp_key is null then 
           ....   cust_id check has failed
       else
            .... process the temporary table, 
            .... or pass the temp_key to front end program
            .... for further processing
       end if;

: My other query is does the stored-procedure behave in the
: same manner as SQL, that I can pass-through from Access?

I don't know this MS-Access product but generally speaking if you mean, are stored procedures executed in server machine like SQL then the answer is yes.

Hope I was answering your question. ;-)

Ari Likki
Yhtyneet Kuvalehdet Oy/United Magazines Ltd Helsinki, Finland Received on Wed Sep 28 1994 - 02:09:01 CET