Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements.
Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...
We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...
how to call reports 6i report from pl/sql code procedure in pdf format
How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.
I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; ...
why is the need of psql when the sql is already avaliable.
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3)...
I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.
Hi Experts, I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer Pls hlp me out with some hints for this.. thanks n advance
How can we insert 50000 rows by using FORALL,please give me entire code?
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take...
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?


