Below are the errors I keep receiving trying to create the sequence and the Trigger code is below the errors. What am I doing wrong?
Error(8,2): PL/SQL: SQL Statement ignored
Error(8,9): P...
Hello Every one,
I have a merge statement ,a nd i am getting the above error.
I have a source table and target table, and I want to fill the target with source.
please have a look @ my ...
Oracle 9i, Unix Environment
From TOAD, I can write to an Oracle Directory using an anonymous block.
If I move this pl/sql inside a package I get
ORA-29289: directory access denied
ORA-0...
This is how I usually initialise an empty cursor,
open <cursor_name> for
select <column1>,
<column2>
from <table_name>
where 1=2;
Is there a better or another way to do...
Hi,
I'm writing a stored procedure to export tables using the Datapump API but it seems to be barely doing anything other than produce the two files, which the log file is empty and the dat...
Dear All,
i want to declare an array in DB package with the columns as below.
MEM_CLIENT_SYM VARCHAR2(26)
SALE_QTY NUMBER(7)
SALE_AMT ...
Hello,
I im interesting about if it's possible, in exection the procedure in PL/SQL, change the user conection, and any examples the source code
Regards
Gerid Garcia
sqlplus login as User system:
want to access v$database to get the database name out by
EXECUTE IMMEDIATE 'select name into v_DBname from v$database';
I got the error:
ORA-00942: t...
Hi,
I have aproblem with this procedure(oracle pl/sql)
CREATE OR REPLACE PROCEDURE sp1
(data_source_cd IN VARCHAR2) AS
TYPE refCur IS REF CURSOR;
c1 refCur;
...
The column OPERAZIONE in the NEREPSTA_STORICO table can assume 2 values: 'IMPORT' or 'EXPORT'.
The column CENTRALE in the NEREPSTA_STORICO table can assume 10500 different values.
The DE...
Dear Experts,
I want to schedule an Oracle stored procedure to run automatically every night. I am using Windows platform. I have scheduled an oracle script to run from a batch file before,...
Please help sdstuber
What I mean by a generic csv reader is that when the PLSQL code is reading the data it might start of identifying that the first comma is at position 6 (meaning that the ...
Hi,
This is a Pl/SQL question
how to call a Function in SELECT statement which returns the Ref Cursor datatype?
I would appreciate your help.
Thanks !
Hi again,
This is probably simple, but I can't get my statement to work with <> or not IN;
CASE WHEN (RuleID) not equal to 'Value1' or not equal to 'Value3' then 1.
Thanks and Happy Hol...
Hi,
I have a View in Oracle that I want to export to a .CSV file. The view returns about 300,000 lines that I need to import into another program. How do it do it? I thought it might eas...
I'm using a send-email package (which works fine), the guts of which are as follows:
mail_conn := utl_smtp.open_connection(mailhost, port);
utl_smtp.helo(mail_conn, mailhost);
u...
How to fetch last N rows of my oracle table ?
How do I select a long data type from an Oracle table using PL/SQL?
If I do:
Select fieldname from tablename
The results in the fieldname are just <LONG> and I need to find out what it ac...
Hi,
Do you know how I return a value in a select statement when an outer join is null....
I want to set a default value for a column when an outer join fails (+)
Select a.id, b.addres...
How to fetch data from a child table by querying on parent table in openjpa which is One-to-Many Relationship.
I have the following query which without an ORDER BY returns about 54,000 records in 10 seconds. With the ORDER BY it takes upwards of 30-40 seconds. The developers here want to avoid the us...
Experts please assist,
I am attempting to create a trigger that will call a procedure to insert data from one table to another when a field is updated in the source table. I apparently don...
I am using Oracle forms, and sometime in the last 7 months web.show_document() stopped working. All I am wanting to do is view a pdf that is stored in the db. Right now I download the pdf to...
Hi
how can i compare two date/times in pl/sql oracle ??
assume i have the folowing numbers:
hh number; -- hour
mm number; -- minutes
this will be (hh:mm)
hh_db number; -- hou...
Can any one give some ideas to write a sql statement which has functionality of similar to using decode with multiple expressions.. for eg.
table has name, type, cost
data : name1, type...
