I need to split an address which is a single string into multiple strings. Below are the requirements to for the pl/sql procedure that splits up the address into the corresponding address lines. The parameters of the procedure are: create or replace procedure split_address ( address in varchar2, al1 out varchar2, al2 out varchar2, al3 o...
how can i call a web-service inside a Pl/SQL with a serialize class in the parameters. knowing that i need to get data from pl/sql and pass it to another web-service which will return the result as XML. so shall i take the data from PL/SQL as data-table or can the PL/SQL understand such complex Type as the class. if either of them how...
Hello! We have a lot of our business logic in an oracle database. So we use a lot of PL/SQL code. We build, test, and debug PL/SQL packages, procedures, triggers, and functions. Our current tool is the PL/SQL Developer (http://www.allroundautomations.com/). What are your tools for PL/SQL coding and why do you prefer it to the PL/SQL De...
I have one package that has different procedures, and one main procedure through which I am calling other procedures. Through the front end, I am passing the procedure name into main(). Is there any way by which the procedure can be called just writing the parameter name containing('Procedure Name that is need to be called')? CREATE O...
Hello. I have oracle dump file from Oracle8. I am trying to import data in Oracle 10. For importing data I am using PL/SQL Developer(buy the way, I have TOAD client). I am doing that by click Tools->Import Tables choose Oracle Import, and then choose Import file. after that click Ok, Done. so How I can find imported tables? I am using "s...
I am really having very hard time making PL/SQL developer PL/SQL Developer work on my windows 7 64-bit OS. I have Oracle 10g standard edition installed already. I tried with PL/SQL developer version 7 and 8 with no luck. Do anyone tried doing it?. Main objective is to just establish a TCP over IP connection to a remote Oracle 10g databas...
Hi All, I am trying to run this code below using Execute Immediate but its not working and values are correct. Please suggest the correct code. declare v_count number:=1; v_conc_name varchar2(400); v_val VARCHAR2(20):='vineet'; BEGIN v_conc_name:='INT_AP_PAY_CONV'; EXECUTE IMMEDIATE 'UPDATE xxx_cnc_prg_details SET ...
Hi guys I'm running some queries in PL/SQL Developer, and one of the columns in the result has 18-digit numbers. Instead of displaying the entire number in the resulting grid, PL/SQL Developer displays only 15 digits in scientific notation. I tried to find a way to change this in the preferences of the program, so that I'll see the ent...