I have a .net webservice I am consuming in PL SQL using utl_http (Oracle 10G). The webservice call times out on every other call right now. This is only happening when I execute the PL SQL block, if I use something like SOAPUI I can spam requests. My code is following this example http://www.lostechies.com/blogs/joshua_lockwood/archive...
How to display a value as follows in oracle: 99.99 as 99.9900, 99.9 as 99.9000, 9.99 as 9.9900, 99 as 99.0000 All cases should be satisfied.. Please help... ...
Hi there, Simple one. I´m a bit of a newvbie with PLSql and oracle's error messages are never too helpful. I want to do a simple trigger to update a column with the current date i.e. 'modified date' column of a table. Getting an odd error though. The idea is simple create table test1 (tcol varchar2(255), tcol2 varchar2(255)) CREATE ...
After doing DEFINE_EDITOR=vi . I wrote SQL > edit sample.sql This is being stored in Jagan/Documents by default. But i want this to be stored in Jagan/Documents/plsql. Can anybody tell how to do this.. ...
Hi, I've been trying to create a PLSQL package that will post into SharePoint through its web services. I've tried doing this using C# and it kind of worked, yet with PLSQL It seems like am having problem authenticating to Sharepoint since it uses Kerberos & NTLM. declare soap_request varchar2(30000); soap_respond varchar2(30000); ht...
Hi, guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly. declare type a is table of number; type b is table of a; arr b := b(a(1, 2), a(3, 4)); begin for i in arr.first .. arr.last loop for j in arr(i).first .. arr(i).last loop dbms_output.put_line(arr(i) (j)); end loop; end ...
Hi, I need to do some auditing on updating a row. So I have a function that receives a parameter of type some_table%ROWTYPE, containing the new values to be saved for that row. I also need to save some info in a history table regarding what column values where changed. I was thinking of getting the column names for some_table from all_...
I need to write a procedure to normalize a record that have multiple tokens concatenated by one char, I need to obtain these tokens splitting the string and insert each one as a new record in a table. Does Oracle have something like a "split" function? ...
First of all I am using Oracle 10g Express So there are three columns I want to select: [domain_name] [index_path] [collection_name] Now there are two columns that I want to be unique (as a group): [domain_name] [index_path] And then I want to select the row baised on when another column [gen_timestamp] is most recent. So my issue ...
I just want to see whether the data is getting inserted on the table or not.. So i have written like this: select count(*) from emp; dbms_lock.sleep(1); select count(*) from emp; So that it will sleep for 1 min . Even after sleep if the 1st count and 2nd count are different then the data is getting inserted into the table. Otherwise...
This question is pointed to those who speak English as their native language. I know it's kinda off-topic, so I am aware it is likely to get closed or voted down to deep negatives, but I'm still curious. :) I suppose this name is not as simple to pronounce as, say, Pascal, Java, Perl, well, put almost any other one here. In Russian, whi...
Here is my code: create or replace procedure date_report (start_date timestamp , end_date timestamp ) is cursor cursor_audit is select audit_id, audit_action, audit_user, audit_date from customer_audit where audit_date between start_date and end_date ; rec cursor_audit%rowtype; begin open cursor_audit; fet...
I have two web applications: a based in web pl/sql and another in jsp My login web page is in pl/sql from this application to access through a link on my jsp page. I want to keep the user session connected in web pl/sql and then I take it in my application jsp. In jsp for set and get values session I use: HttpSession session = request.g...
How to use put function.my procedure is not compiling with put. but putline is working fine. i want to print in the same line ...
I want to know the difference between these two statements. Is one 'better' than the other ? DECLARE myvar varchar2(50); BEGIN SELECT fieldone into myvar FROM tbl_one WHERE id = 1; END; AND DECLARE CURSOR L1 IS SELECT fieldone FROM tbl_one WHERE id = 1; BEGIN OPEN L1; FETCH L1 INTO myvar; CLOSE L1; END; ...
Hi All, I am writing a PL/SQL parser to identify the operations(Select,Insert,Delete) performed on the Table when I run Procedure, Function or Package. GOAL:I Goal of this tool is to identify which all the tables will be affected by running the procedure,Fun to prepare with better test case. Any better ideas or tool will really help a...
I have a table like this: UserID Customer ID status 1 1 1 1 2 1 1 3 1 1 4 2 1 5 1 1 6 3 1 7 2 2 8 1 2 9 2 ........ ...
I want a specific order for the Completion_Status column as in: Completed, Passed, Incomplete & Failed How do I do I order this? I want to define the order above. I tried CASE but it give me an error as in Expecting NUM not CHAR. select DISTINCT u.first_name || ' ' || u.last_name "Employee_Name", rco.title "Course_Name", deco...
I am using Oracle SQL Developer. I am using parameters &TableName My query comes back to me in the results with an OLD: tag before it, and again with a New: tag (the variable is replaced with the value that I have typed in) and then my results follow this. How do I get rid of this annoying return and change it to just display my resul...
I have to load 46 tables with data using SQL Loader for Oracle. All the data files are CSV. The column order in the CSV matches the column order in the table. I need to create a control file for each table. What is the best way for me to mass produce these files? ...