I receive the folowing error when I run the following procedure, when I use the hardcoded str_sql and uncomment execute immediate it works fine.
What am I missing Thanks.
begin
admin_qa.u...
Hi
I can I find oracle patch is installed on the machine. Is there any table which I query?
Recommended patches on top of 10.2.0.3 should be: 6081550, 6081547,6267873,6043052,6375952, 50...
I have two separate Oracle databases - one is 10.1.0.2.0 (Dev database) and the other is 10.1.0.4.0 (Test database) - on two separate servers. In each of these databases I have identical sche...
Hello all,
Im trying to connect to an Oracle server but im not sure where i have gone wrong and i get the above message when i try to test the connection using the Net8 Assistant.
Following ...
I'm GETTING ORA-01031 ON EXECUTE IMMEDIATe while executing proc.
I have a privelge to create table, which privileges need to be granted to my account to execute this command successfully?
Does anybody know where I could find some detailed documentation about creating Oracle Forms data blocks using stored procedures?
All,
Listed below is my code. I get the following errors when trying to execute:
EXCEPTION
*
ERROR at line 57:
ORA-06550: line 57, column 10:
PLS-00103: Encountered the symbol "EXC...
Hi
I attached webutil.pll library by following method
* Open webutil.pll, do a "Compile ALL" (shift-Control-K), and generate to PLX (Control-T)
Library is attached successfully,...
How to get this to work in oracle:
SELECT LAST(VALUE) AS RESULT FROM RESULTS
WHERE MRC_ID = 5 AND RESULT_DATE < TO_DATE('01/01/2006', 'DD/MM/YYYY')
GROUP BY RESULT_DATE ORDER BY RESULT_...
Oracle 9i
Wink 2k
I modified a file in oracle9i/database called SPFILEORCL9I.ORA I assumed it was
the init .ora file.
When I made a change oracle stopped working when I reverted back to...
Getting the following execution error
SQL execution error, ORA-06550: line 1, column 7:
PLS-00103: Encounter the symbol "." when expecting one of the following:
begin declare exit for ...
//CALL PROCEDURE
PROCEDURE GEN_LPC_DETAILS(
P_brncd IN LN02REP2.BRNCD%TYPE , //this is VARCHAR2(5)
P_modcd IN LN02REP2.MODCD%TYPE , ...
I need to copy a table identicaly to another. I use this command to do it : CREATE TABLE target AS SELECT * FROM source
But i've got an ORA-00997 error : illegal use of LONG datatype, becau...
This is driving me nuts. I have ended up studying the whole Oracle Networking to resolve this but am unable to fix it.
Earlier I had Oracle 8i client installed on my system. I had it remove...
How can I have multple conditiopns in a case statement
I need something like this
select distinct
chemistry,
iassaynumber,
(CASE mathmodelid
WHEN 12 or 32 or 71 or 84 THE...
In the line
StrDate DATE DEFAULT SYSDATE;
I would like to have a DEFAULT SYSDATE format : 'DD-MON-YYYY HH24:MI:SS' ... only for this particular field .. the others have the format 'DD-M...
i have 2 columns in a table which contains date in the Julian Format.But i need to convert them to standard date when i am selecting the data from this table .
hi,
I am using mssql with oledb,
I have this sql text like:
;===========================================
IF (select count(*) from table_user where userid=1700))=0
INSERT INTO table_user...
Hi,
I need to retrieve record from the Oracle database by comparing with a time range? The column "OTime" is of Date datatype. I'm using ASP.
This is my SQL:
"SELECT * FROM Purchase WHE...
SELECT CST_SERVICE_ORDER.SERVICE_ORDER_NO
FROM
CST_SERVICE_ORDER
WHERE
CASE WHEN '12-31-9999' ='12-31-9999'
THEN
CST_SERVICE_ORDER.COMPLETED_DATE='01-01-2005'
ELSE
CST_SERVICE_ORDER.R...
Would anyone know if the newer versions of Oracle dbs support a date/time format up to milliseconds?
I've been told that the only way I can store the date/time in milliseconds is to use a v...
I'm trying to use bind variables in some stored procedures I'm writing in Oracle 10g (sqlplus version 9.2.0.1.0). For example:
sqlplus>variable v NUMBER;
sqlplus>begin
2 :v=10;
3 end;
4 /...
Hi,
A customer of ours is having problems starting up their oracle database. When the database startsup,
it starts the instance ok and it mounts the database ok, however when it comes to ...
Hi Friend
I want to drop a job that is schedule to run a procedure
what is a command I need to use to drop the job.
Thanks
I need help resolving this error. I got this error this morning on the new pc I am setting up. As far as I can remember it was working yesterday when I shut down. After I got this error I bl...
