Re: OWS and PL/SQL
Date: Tue, 30 Jun 1998 21:08:17 GMT
Message-ID: <35995319.2409084_at_192.86.155.100>
A copy of this was sent to bubbaq_at_my-dejanews.com (if that email address didn't require changing) On Tue, 30 Jun 1998 17:57:28 GMT, you wrote:
>Hello All,
>
> I am working on a HTML form-processing application using PL/SQL and OWS. I
>am relatively new to this environment (coming from a C,Perl,and Python CGI
>backround). I am a bit confused about the manner in which form data is
>passed to my PL/SQL cartridge. It seems that the name-value relationships
>are not preserved, and that the form data is simply passed in the order that
>it appears on the HTML page. Am I missing something? I really need to be
>able to access the form data by name, not location. Any help would greatly
>appreciated.
>
the plsql cartridge takes a URL like:
http://hostname/dcdname/owa/some_procedure?z=5&x=10&a=Hello+World
And maps that to a database call like:
begin
some_procedure( a => :a, x => :x, z => :z ); end;
That is, the named values in the URL are mapped to named formal parameters in the pl/sql routine. They are not passed 'first in first out' but rather bound to named input variables to the procedure.
OAS4.x will allow you to instead have the variables saved in a pair of arrays, sort of like an associative array, and have a procedure some_procedure that recieves these arrays instead of named formal parameters -- your procedure would get an array of names and an array of values passed to it.
>Many Thanks,
>Jack Erwin
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Jun 30 1998 - 23:08:17 CEST