Hi,
I would like to ask the experts if is it possible to create dynamic cusrsor in PL/SQL language where as parameter will be used table name.
Declare CURSOR cur is Select * from <defined...
My session was showing date format as DD-MON-RR
So I did:
select value from nls_session_parameters where parameter = 'NLS_DATE_FORMAT'
--was DD-MON-RR
ALTER SESSION SET NLS_DATE_FORMAT = '...
I have datablock in a form contain 2 rows and 2 colums
I need to Display 2 records cpacified by where condition in this data block in oracle form
but
The problem it display only last reco...
Hi,
When I am trying to write clob data more than 32 KB into a text file using utl_file, I am facing issues.
I ma getting an error:
Error: ORA-29285: file write error
ORA-06512: at line 28...
Hi,
I have a stored procedure 'A' in this I call another procedure 'B'. I have defined a cursor in 'A' which I want to pass by reference into 'B' then execute SQL in 'B' using the cursor pa...
There is a primary key(constraint_pk) on col1 and col2 of the table Sample
Step 1: Dropping existing constraint
Alter table Sample drop constraint constraint_pk;
Successfully completed
...
Exception: -29532 ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.net.SocketPermission 192.168.101.1:25 connect,resolve) ...
Hi
I am trying to do export of some table which are more then 20GB.
The problem is the database is on remote server.
Is it possible to export dump file directly on to local machine.
How ...
Hi experts,
I have a task in my hand - Have to generate XML file from the result set generated by a select query. The business req'mt is like...user will provide one input value say FILING_...
Hey Guys,
I'm working on a cursor for loop which pulled different number of records based on week_id. I want to be able to insert this records in a temp table every time it goes through the...
Hi, This query seems to not be doing the second subtraction that I am intending, but rather returning its original value. i am looking to return the midpoint of the two values.
select t.nbb...
Hi,
I am trying to write a SQL statement using XMLQuery that returns a list of books and the GUID assigned to them. I have two columns: (1) GUID - Varchar2 (2) XML_DOC - XMLType. Th...
Before I remove some items, everything seems working. After I remove inventory_item_id on the media_request_info block, the list status can change whatever I want but with the following messag...
Hi,
I have a text list to use with IN operator - IN ('a','b') yet i need to compare it to a field that might contain the value of a;b so i want to put wild cards in the IN list??? Doesn't s...
When I enter this...
insert into criminal values ('D6','Diablo',10,'Male', 'Yes');
it causes a trigger to react but theres a problem here is the error...
ORA-01403: no data found
ORA...
I am unable to perform a simple division in PL/SQL.
I am new to PL/SQL and try the following operation and but my Stored Procedure seems to break at this point.
cRec.RC_FACTOR1 never conta...
Hi,
I have a statement below, but when execute in the PL/SQL, i get an error.
My question is :
a.) Is oracle 9i support case when in update statement when using MERGE
b.) I try use WHERE a...
I have a query which does group by and is really slow. can I create a materialzed view on group by fields and create index on it ? an example would be helpful.
I am trying to write conflict resolution procedure. When I try to raise a conflict it is not handle properly. I went o dba_apply_error and see below message. Can you please help me how to reso...
Hi,
Need your help. I am very weak on this. I want to put below output of below sql to my UTL_SMTP send by a trigger in the code section:
Code:
-------
select * from ETL_ERR_EXT_LOTS_...
Hi.
I have a function:
calc_pay
I call this in a sql statement and it hangs, i would like to know how i could debug pl-sql functions like i can in other languages.
First is there any...
Hello Everyone,
I am new to PLSQL and the issue I am facing with it is the : pkg_body is in invalid state. I need to run a report, and for that reason I need it to be valid. when I checked ...
Can anyone provide Oracle SQL to accomplish the following
v500.TRACKING_CHECKIN.CHECKIN_DT_TM BETWEEN DateTime.Today.AddDays(-1).ToString("dd-MMM-yyyy") AND
DateTime.Toda...
I am trying to load the data from one table to another - The base table contains all the sales history - and I am trying to break it down into several tables Sale, Sale detail, and so on. All...
Hi,
How can I retrieve the output from a stored procedure in TOAD in the "SQL editor"? I know I can do it in SQLplus, but thats rather unhandy if my resultset has thousands of records, becaus...
