| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.7 doc online anywhere?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06B95.1074C0C0
Content-Type: text/plain;
charset="iso-8859-1"
Does anyone know where I can find 8.1.7 doc on the web? Metalink pdf's for 8.1.7 Migration, and the README won't load.
Any reference is apreciated!
Thanks, Linda
------_=_NextPart_001_01C06B95.1074C0C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>8.1.7 doc online anywhere? </TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Does anyone know where I can find =
8.1.7 doc on the web? Metalink pdf's for 8.1.7 Migration, and the =
README won't load. </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any reference is apreciated! =
</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks, Linda </FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C06B95.1074C0C0--
From: Viktor <stant_98_at_yahoo.com>
Date: Thu, 21 Dec 2000 13:39:10 -0800 (PST)
Subject: Dynamic PL/SQL
--0-610515434-977434750=:5535
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Hello all,
I have a dynamic PL/SQL procedure that selects author_name. For some reason author names that contain
"'" cause the procedure to fail.
Does anyone have experienced this before and has a
solution?
Attached is a section from the procedure.
Thanks.
Content-Type: text/plain; name="Proc.txt" Content-Description: Proc.txt Content-Disposition: inline; filename="Proc.txt"
LOOP
/* BUILD THE SELECT STATEMENT */
ls_select_statement := 'SELECT J.JOURNAL_ID, M.SPLIT_CODE, P.PUBKEY_JCODE||P.PUBKEY_YRISSUE||P.PUBKEY_MS_SEQNO||P.PUBKEY_CKCHAR, J.JOURNAL_NAME,
P.CAS_RECV_DATE , P.PUBLISH_DATE , M.NO_SUPP_PAGES, P.SUPP_MAT_OTHER, REPLACE(MS.AUTHOR_LASTNAME,'''','' '')
FROM '||R_SCHEMA.J_ID||'.JOURNAL J,'||R_SCHEMA.J_ID||'.PUBSTAT P,
'||R_SCHEMA.J_ID||'.MSCRIPT M,'||R_SCHEMA.J_ID||'.MSAUTHOR MS
WHERE P.PUBKEY_JCODE=J.JOURNAL_ID
AND P.PUBKEY_JCODE = M.JOURNAL_ID
AND P.PUBKEY_YRISSUE = M.YR_OF_ISSUE
AND P.PUBKEY_MS_SEQNO = M.MS_SEQUENCE_NO
AND P.PUBKEY_CKCHAR = M.CHECK_CHAR
AND MS.AUTHMSNO_JCODE(+) = P.PUBKEY_JCODE
AND MS.AUTHMSNO_YRISSUE(+) = P.PUBKEY_YRISSUE
AND MS.AUTHMSNO_MS_SEQNO(+)= P.PUBKEY_MS_SEQNO
AND MS.AUTHMSNO_CKCHAR(+)= P.PUBKEY_CKCHAR
AND MS.DISPLAY_SEQUENCE = 1
AND P.PUBKEY_JCODE||P.PUBKEY_YRISSUE||P.PUBKEY_MS_SEQNO||P.PUBKEY_CKCHAR = ''JA005514C''
AND (M.NO_SUPP_PAGES > 0 OR P.SUPP_MAT_OTHER > 0)
AND P.cas_recv_date between '||''''||sdate ||''''||' and '||''''|| edate ||'''' ;
li_cursor_id := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.parse(li_cursor_id, ls_select_statement,1);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 1, v_journal_id, 2);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 2, v_split_code, 2);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 3, v_msno,9);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 4, v_journal_name,50);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 5, v_recv_date);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 6, v_pub_date);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 7, v_no_supp_pages);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 8, v_supp_mat_other);
DBMS_SQL.DEFINE_COLUMN(li_cursor_id, 9, v_author_lastname,30);
li_rc := DBMS_SQL.EXECUTE(li_cursor_id);
LOOP
EXIT WHEN DBMS_SQL.FETCH_ROWS(li_cursor_id) = 0;
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 1, v_journal_id);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 2, v_split_code);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 3, v_msno);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 4, v_journal_name);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 5, v_recv_date);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 6, v_pub_date);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 7, v_no_supp_pages);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 8, v_supp_mat_other);
DBMS_SQL.COLUMN_VALUE(li_cursor_id, 9, v_author_lastname);
ls_insert_statement := 'INSERT INTO '||use_name||'.manuscript_pages_received VALUES(';
ls_insert_statement := ls_insert_statement ||''''||v_journal_id||''''
||','||''''||v_split_code||''''
||','||''''||v_msno||''''
||','||''''||v_journal_name||''''
||','||''''||v_recv_date||''''
||','||''''||v_pub_date||''''
||','||v_no_supp_pages||
','||v_supp_mat_other||
','||''''||v_author_lastname||''''||')';
li_cursor_id1 := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(li_cursor_id1, ls_insert_statement, 1);
li_rc := DBMS_SQL.EXECUTE(li_cursor_id1);
dbms_output.put_line (v_msno||' '||v_author_lastname);
DBMS_SQL.CLOSE_CURSOR(li_cursor_id1);
END LOOP;
DBMS_SQL.CLOSE_CURSOR(li_cursor_id);
END LOOP;
From: WIlliam Thater <thaterw_at_telergy.net>
Date: Thu, 21 Dec 2000 16:39:13 -0500
Subject: Re: DBA - Job boundaries & perks
Rachel Carmichael wrote:
> > he knows more than he thinks he does....... he'd just be scared for a long > time
oh heck, i've been in a state of scared for going on 8 or 10 years now, you get used to it.;-)
-- Bill Thater Sr. ORACLE DBA Telergy, Inc thaterw_at_telergy.net ---------------------------------------------------------------- "Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." -- Albert Einstein ---------------------------------------------------------------- ------------------------------ From: "Holman, Rodney" <rodney.holman_at_lodgenet.com> Date: Thu, 21 Dec 2000 15:49:22 -0600 Subject: RE: TNS_ADMIN variable location :Unix/Nt On NT you set this in the registry at: \\HKEY_LOCAL_MACHINE\Software\Oracle Add a string named TNS_ADMIN and set the value to where you want your SQLNET.ORA and TNSNAMES.ORA located. Rodd -----Original Message----- From: Ravindra Basavaraja [mailto:ravindra_at_sentica.com] Sent: Thursday, December 21, 2000 03:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: TNS_ADMIN variable location :Unix/Nt that is a environment parameter to be set. on unix set that to point to the directory where the network files = are.set this in the oracle .profile file. $echo $TNS_ADMIN should point to the right directory ravindra -----Original Message----- Sent: Monday, December 18, 2000 5:56 PM To: Multiple recipients of list ORACLE-L On Mon, 18 Dec 2000, arif wrote: > Hi ALL, > > Can anyone let me know as to where the TNS_ADMIN variable is located. > > Many Thanks and Regards, > Arif Khan It is normally set to $ORACLE_HOME/network/admin, or on Windoze %ORACLE_HOME%\net80\admin > > Schoen Volker wrote: > > > Hi list, > > > > I have a costumer, which has a system tablespaces with 1.2 GB. = Default > > storage parameter fpr initial and next extent are 102400 KB. My question, > > how can I minimize and reorganize system tablespace, Full DB = export? Or is > > there another easier method? > > > > TIA > > > > Volker Sch=F6n > > E-Mail: mailto:v.schoen_at_inplan.de > > http://www.inplan.de > > > > -------- > > Think you know someone who can answer the above question? Forward = it to them! > > to unsubscribe, send a blank email to = oracledba-unsubscribe_at_LAZYDBA.com > > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com jared_still_at_enron.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jared still INET: jkstill_at_teleport.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inReceived on Thu Dec 21 2000 - 15:29:13 CST
 |
 |