Re: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
I think that this require a deeper investigation. Last night I tried to use alter system sql_trace=true and it did not work either. I had to put sql_trace=true in init.ora and to bounce the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 8:18 PM All Im trying to run the following statement EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE) And get the following error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored Looking under SYS schema I have package and package body for DBMS_SYSTEM and the body includes SET_SQL_TRACE_IN_SESSION I had to turn on tracing on the database level... What could be the matter with this?? Many Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
prefix it with sys. ie: EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE); Yechiel Adar <[EMAIL PROTECTED]>wrote: I think that this require a deeper investigation.Last night I tried to use alter system sql_trace=true and it did not workeither.I had to put sql_trace=true in init.ora and to bounce the database.Yechiel AdarMehish- Original Message -To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent: Thursday, October 03, 2002 8:18 PMAll Im trying to run the following statementEXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)And get the following errorERROR at line 1:ORA-06550: line 1, column 7:PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must bedeclaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredLooking under SYS schema I have package and package body for DBMS_SYSTEMand the body includesSET_SQL_TRACE_IN_SESSIONI had to turn on tracin! ! g on the database level...What could be the matter with this??Many Thanks in advancebob--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Bob MetelskyINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Yechiel AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.c! ! omSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
Cary Millsap's course and a new article
I attended Cary's and Jeff's Hotsos Clinic last week. It was really good. I wrote a short review, which probably doesn't do the course justice, at the following URL: http://www.oreillynet.com/pub/wlg/2111 I also wrote a short article last week about an aspect of Oracle's newly-supported SQL92 join syntax that really surprised me: http://www.oreillynet.com/pub/a/network/2002/10/01/whatsinacondition.html Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * mailto:[EMAIL PROTECTED] * 906.387.1698 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Shell scripting
hi
well i think i did this once, you can read
the output of the SQL query into shell variables by
first redirecting the output of the SQL query to an
OS file and then reading the file and loading
the data in the file into shell variables.
/* here is sample code to redirect the output of sql query to OS file */
#!/bin/sh
CMD_FILE=sql_input.sql
LOC_FILE=output.log
SQLCMD="connect internal ;
select * from sys.dba_users ;"
echo "$SQLCMD" > ${CMD_FILE}
svrmgrl < ${CMD_FILE} > ${LOC_FILE} /* redirecting the out of
svrmgrl to OS file */
regards
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
Omar Khalid
Software Engineer
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'
"Cyril
Thankappan" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Shell scripting
Sent by:
[EMAIL PROTECTED]
10/04/2002 09:18
PM
Please respond to
ORACLE-L
Hi
I wanted to select a column from a v$ table
struggled with it
and finally came with a workaround as follows
archived_log='$archived_log'
begin_seq=`sqlplus -s /nolog
RE: ora-305500
Thank you, Lynda, it worked. Aleem -Original Message- Sent: Saturday, October 05, 2002 7:23 PM To: Multiple recipients of list ORACLE-L Subject:RE: ora-305500 It is the line that contains (--) in the beginning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
remove & move a user
Hi, what's the best method to 1) remove a user absolutely. I want to remove the user's tables, indexes, ... etc. 2) move a user absolutely to another tablespace. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
