Home > > How to use PL/SQL in javascript

How to use PL/SQL in javascript

Hi, Iam trying to do the following:
I need to call a function PL-SQL from javascript. In Oracle I can do this with sth like:
variable result varchar2(100);
exec :result := MyFunction(param1, param2);
(a string with a varible long returns)
Someone could help me and tell me which is the right way to do this in javascript?
Veronica Loureda
I don't think you can execute PL/SQL from javascript.
Read the other 2 answers
I'm new to LiveCycle - be gentle. . . :-) My department is attempting to develop a web application which will, among other things, generate fixed layout forms filled with data from the database or from an application web page. The web pages for this
I am using an html form to get user input via radio buttons via the following segment htp.p('<input type="radio" value="a" onSelect="saySomething('fish')">'); However, when the brackets surrounding (fish) are encountere
Hi, I was wondering whether anyone has been able to successfully call a PL/SQL function from JavaScript and have the PL/SQL function return a result to the calling JavaScript function. What I am wanting to do is, depending on what the value returned
Hi all, I'm having some performance issues with a dynamic action. Will name this action DA_UPDATE_OPM This action should run unconditionally on the change of almost any item on a region and results in the setting of just 1 field. Since all items are
For example, my dynamic page contains such PL/SQL codes: <ORACLE> DECLARE info varchar(100); rowid urowid; procedure doDelete( row_id in urowid ) IS begin Delete From xxx WHERE rowid = row_id; end doDelete; BEGIN Select name, rowid INTO info, rowid
Dear all, I'm trying to call a PL/SQL procedure from JS and return a value to JS code. I'm using the htmldb_Get method but I cannot succeed doing this. My PL/SQL : BEGIN htp.prn('Hello World'); END; My JS : function test() { var get = new htmldb_Get(
Hi, Can someone please tell me why this code is not working..... I have put this in my pl/sql process.... htp.p('<script language=javascript>'); htp.p('var r=confirm("This is a duplicate record , do you want to proceed?");'); htp.p('if (r=
I generated module as web pl/sql in Oracle Design Editor 6i. I have different user types with different privileges. I want to do some permission checking before a user can reach the tables. All the help are related to API and Form. Is there a way to
Hi, I have set a button in a tabular form that runs a dynamic action made up of 2 parts in sequence: (1) a PL/SQL code that updates a collection using g_f01 (selected items in the tabular form) (2) a javascript that calls apex.server.process to displ
Hey, I've been contacted by a job recruiter about an entry level position requiring Java, Oracle SQL, and Javascript knowledge. I'm currently studying for the SCJP6 test, but are there any decent free crash courses on Oracle SQL? I have previously ta
I have a PL/SQL, HTML, JavaScript procedure that is giving me a HTTP 404 error when I press the 'SUBMIT' button. I have tried to trap it in the procedure but am unable. Does anyone know what parameter(s) need to be turned on in the Apache server to d
Hi, I hope this is the correct forum for this. We have two html select lists where I would like to display the values of second list based on what is selected in the first list (e.g., country and states). I was hoping to achieve this using AJAX and P
Hopefully this is an easy one guys, I've added a select list item to the standard login page (P101) to allow the user to select a DOMAIN as well as entering their username and password. When the next page is displayed and I try to retrieve the value
Hi, Apex 4.1 can anyone tell me which steps to take excactly to manually create a second detail region on a master-detail form ? So far I've copied the first detail region and customized it to the second detail table. Copied the processes and adjuste
hi, my sapscript form needs to be printed out in 2 languages EL and PL. We created custom output types and copied MEDRUCK form for this. my problem is, it is printing out in PL language but the format is getting from the standard form, even if we use
hey.....my database generates date in xml in following format <date>1993-02-27T00:00:00+05:30</date> i wish to show and sort this date in the form 27-02-93 how can i do it?You can ask your database to return it in the format you want, assuming
I have the following position available. If you are interested or know anyone who is please forward resume and contact information to Lisa Green: [email protected] OVERVIEW: The LiveCycle Developer is responsible for providing administration, technic
Hello,       I have the following position located in Timonium, MD for a Adobe LiveCycle Developer. If you are interested or know anyone looking to forward resume to [email protected] Thank you, OVERVIEW: The LiveCycle Developer is responsible for pr
Objective: To obtain a position as an Oracle/Web Developer Qualifications Summary: Strong knowledge of object-relational database development and client/server technology, experience in application design. Operating Systems: Linux, Windows NT, MS-DOS