Return Values from a function

Results 1 to 3 of 3

Thread: Return Values from a function

  1. #1
    Cathy Chan Guest

    Default Return Values from a function

    Instead of having a store procedure, I have Oracle guys set up for me from back end this SELECT statement<BR><BR>select adminuser.av_res_check(item_id, start_date, end_date) from dual<BR><BR>How do I put this select statement into a function, to Insert my form values into the database and return a values to start my BRANCHING statement, <BR>if select = "NO" or "VAL" then<BR>response.write "wrong"<BR>response.redirect "form.asp<BR>else<BR>INSERT INTO ADMINUSER.AV_RESERVATION (RESERVATION_ID, INVENTORY_ID, START_DATE, END_DATE, OUID)<BR>VALUES (ADMINUSER.PK, V_INVENTORY_ID, V_START_DATE, V_END_DATE, V_OUID); <BR><BR>How do I make that insert into the ASP ?<BR><BR>Please help!

  2. #2
    Join Date
    Dec 1969

    Default Try Harder

    Dear Cathy,<BR><BR>thought you might have learnt yesterday, stop, read over yesterdays answers you were given about asking questions.<BR><BR>The answer to todays question is use ADO! Don&#039;t want to be hard on you so have a look at this site, use the search, there will be answers.

  3. #3
    Join Date
    Dec 1969

    Default RE: Try Harder

    Thank you! I will look on the site!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts