Title: Dynamic cursor in PL/SQL
Hi gurus,
I have to do a stored proc to compare the data of two tables in different schemas. I want to use a dynamic cursor and select the content of a table passed in argument.
I saw in a document that I can work with REF CURSOR like this instance:
Title: IAS-Apache and PHP
Hi gurus,
Has anyone tried to include a PHP module to Apache in IAS ?
Does Oracle support it?
We have some PL/SQL applications (drive by OAS) that we need to migrate to IAS. We have some other new applications in PHP. Do we have to maintain two Apaches (one in IAS
Title: RE: init.ora
Hi Prasad,
When your issue STARTUP command in svrmgrl or sqlplus, Oracle will check the file called initSID.ora in the $ORACLE_HOME/dbs directory.
You could specify a initSID.ora file with this command : STARTUP PFILE=/PATH/initSID.ora
Luc
-Message
Title: OEM 2.2 client for Sun
Hi gurus,
We work with OEM 2.1 client on PC and Sun stations and we wish to upgrade to OEM 2.2 (we have DBAs on Sun stations).
I can't find OEM 2.2 client for Sun on the Sun Solaris 8.1.7 CD pack, I can only find it for Windows. Is it just me or does Oracle
Title: PFILE location in NT
Hi
Shahid,
Did
you specify a PFILE parameter in your startup ?
If
not, on NT, the default location for the parameter file is
ORACLE_HOME\database. Your database is using the file in this
location.
Luc
-Message
d'origine-De: Shahid Nasir
Title: Question about LMT
Hi all,
I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index.
My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ?
Example : datafile size = 500M + 64 Kb = 512064 Kb
resize to
-From: DEMANCHE
Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05To: Multiple recipients of list
ORACLE-LSubject: Question
about LMT
Hi all,
I created a tablespace in
LMT. I created all my datafiles with an extra 64 Kb for the bitmap
index.
My
Title: RE: Oracle 8i database ER diagram
Hi Magesh,
We use ER-Win to manage our ER diagram. You can do a Reverse Engineer to create your first ER diagram. After that, you make changes in your ER Diagram and apply this changes by ER-Win.
Luc
-Message d'origine-
De: magesh
Title: RE: Changing Java pool size to 0
Hi Ramesh
The java_pool_size is use want you work with the JServer. Do you have a Java stored proc, EJB or CORBA in your DB ? If not, you don't need the java_pool_size.
You could set it to 0. The default is 1m.
Luc
-Message d'origine-
Title: RE: BACKUP CONTROLFILE TRACE
Hi Nirmal,
The command 'alter database backup controlfile to trace' will dump the control file content on a text file with all the SQL command to recreate it. You gonna find your text file (.trc) in your USER_DUMP_DEST directory.
To test it, you can do
Title: RE: sort_area_size + temp tablespace extent sizing
Stephane,
What situation would make you choose a certain value (i.e.: using '3' versus '4.5')?
-Message d'origine-
De: paquette stephane [mailto:[EMAIL PROTECTED]]
Date: Tuesday, April 24, 2001 6:03 PM
À: Multiple
Title: Manage of 9IAS
Hi gurus,
I installed 9IAS on a Unix server. I installed all Oracle products with the Unix user ORACLE and its primary group OINSTALL.
My installation is done, but I want to manage my IAS with another user called IAS and primary group DBA.
My problem is :
Everything
Title: Crontab
Hi gurus,
I want to schedule a script to run on the fourth sunday of the month.
How can I do that ?
TIA
-
Luc Demanche
CETELEM
Tél.: 01-46-39-14-49
Fax : 01-46-39-59-88
Title: insertion into CLOB
Hi gurus,
Oracle 8.1.6.2
Solaris 2.6
I'm doing some tests with a CLOB field. I created a stored procedure, which inserts text into a CLOB.
Here is my table :
create table relance (nom varchar2(50), texte CLOB);
Here is my code :
create or replace procedure
14 matches
Mail list logo