Forum Stats

  • 3,783,343 Users
  • 2,254,760 Discussions
  • 7,880,369 Comments

Discussions

Passing multiple records pl/sql through link

2955247
2955247 Member Posts: 1
edited Jun 1, 2015 12:32AM in SQL & PL/SQL

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.

Tagged:

Answers

This discussion has been closed.