var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how do we call a storedprocedure from HTML
first of all HAPPY NEW YEAR TO ALL,
i want to know how do we call a pl/sql server page(PSP) from a HTML page? is it possible ? can you give a reply for this.
Happy new year to you too.
You will have to set up a Database Access Descriptor (DAD) while using iAS or the Apache listener that comes with the database.
When setting it up, there is are some fields that will have to filled out: name the dad; username needs to have the schema name in which you loaded the psp; and password for the schema.
So, what you get is something like this:
DAD name: db_packages
Would recommend stopping and re-starting Apache/iAS at this point.
From your browser try:
Hope this helps.
and if you want to call PL/SQL and pass in parameters just do the following
Note that the parameter names have to be the same as the parameter names in the procudure.