Passing multiple records pl/sql through link

2955247

I want to pass multiple variables throught link to my procedure.Everthing is good when i'm trying to pass one record, but i can't solve problem when i have to pass two records.

I was trying with # ,& ,?  but no succes ;(

This works for one record.

<span class="pln" style="color: #000000;">htp</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">tableRowOpen</span><span class="pun" style="color: #000000;">(</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">,</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">);</span><span class="pln" style="color: #000000;">  <br/>  htp</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">tableData</span><span class="pun" style="color: #000000;">(</span><span class="pln" style="color: #000000;">rekord</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">Name</span><span class="pun" style="color: #000000;">,</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">,</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">);</span><span class="pln" style="color: #000000;"> <br/>  htp</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">tableData</span><span class="pun" style="color: #000000;">(</span><span class="str" style="color: #800000;"><span>'<A Href=</span><a class="jive-link-external-small" href="http://localhost:8080/my_epg_dad/Client.AddProduct?id=" rel="nofollow">http://localhost:8080/my_epg_dad/Client.AddProduct?id=</a><span>'</span></span><span class="pun" style="color: #000000;">||</span><span class="pln" style="color: #000000;">rekord</span><span class="pun" style="color: #000000;">.</span><span class="pln" style="color: #000000;">id_product</span><span class="pun" style="color: #000000;">||</span><span class="str" style="color: #800000;">'>Add</a>'</span><span class="pun" style="color: #000000;">,</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">,</span><span class="lit" style="color: #800000;">2</span><span class="pun" style="color: #000000;">);</span>

For one variable like this below it works.

Billy Verreynne

The query string in the URL must match the PL/SQL procedure's parameter signature.

For example, if procedure look like this:

create or replace procedure Foo( id number ) is

Then the query string looks like this:

http://whatever.com/dad/schema.foo?id=123

For example, if procedure look like this:

create or replace procedure Foo( id1 number, id2 number ) is

Then the query string looks like this:

http://whatever.com/dad/schema.foo?id1=123,id2=345