Active Directory and ORACLE passwords
Title: Active Directory and ORACLE passwords Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the password would be valid and then pass off to the ORACLE database that password. Any information would help. Thanks in advance David
Permissions error
Title: Permissions error Hi All I get this error when I try to log into sqlplus from my DEC ALPHA machine through a telnet session. Enter user-name: testid Enter password: ERROR: ORA-01034: ORACLE not available ORA-07320: smsget: shmat error when trying to attach sga. DEC OSF/1 (AXP) Error: 13: Permission denied Did some permissions get corrupted. I am able to connect using sqlplus from my oracle account. This happens when I try to connect from a different account. Thanks David
Take an Oracle 8.1 export file back to an Oracle 7.1 database.
Title: Take an Oracle 8.1 export file back to an Oracle 7.1 database. Hi all Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there some other method I can use to get the data from the 8.1 export file to the 7.1 database. Thanks David
Export from Oracle 8 to Oracle 7
Hi all Can I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1? Is there a setting in the export utility to be backward compatible with V7? Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David 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).
TEST PLEASE DELETE
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
OPS$users
Hi all, Is there some db parameter I need to set to get the ops$ login to work? I am using ORACLE V8.1.7 on a Compaq Tru64 V5.1 I have created a unix user called production. I then created the user in the database called ops$production. When I login as this user and try to go into SQL*PLUS I get an invalid username/password error. I get the error if I type: sqlplus / or sqlplus get the username prompt and hit enter. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
Convert 7.3 users to 8.17 users
Hi all Can I take all the users created in a 7.3 database and somehow import them into a 8.1.7 database with the original passwords and roles/access to tables? TIA David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
Connect as a different user in PL/SQL
Hi all, Is there a way to connect or see if a username and password are valid in a PL/SQL procedure? I will come in as one user. Pass in the username and password I want to validate. Try to connect to the database with that username and password. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: No control files created.
$ORACLE_HOME and ORACLE_SID have been set correctly. Can I just recreate the control files? David -Original Message- Sent: Tuesday, July 31, 2001 1:23 PM To: Multiple recipients of list ORACLE-L Have you checked $ORACLE_HOME/dbs directory for control files? Are you using/set ORACLE_SID correctly before starting database? MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 31 Jul 2001 10:57:22 -0800 Yes, All the default datafiles and database was created. David -Original Message- Sent: Tuesday, July 31, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Did you create the database? Or, just installed oracle software? Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 1:46 PM Hi all, I have a new install of Oracle 8.1.7 on a Compaq ES40. The install all went fine, (so it seemed) I tried starting up the db and got the error ORA-00205 Error in identifying controlfile, check alert log for more info. I looked around the entire system thinking the control files were incorrectly placed. The control files are not to be found. There is no alert log to look at. Can anyone tell me what may have happened to the control files and how I can get them back? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: Igor Neyman INET: [EMAIL PROTECTED] 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: [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: Bartolo, David INET: [EMAIL PROTECTED] 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: [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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] 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: [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: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
No control files created.
Hi all, I have a new install of Oracle 8.1.7 on a Compaq ES40. The install all went fine, (so it seemed) I tried starting up the db and got the error ORA-00205 Error in identifying controlfile, check alert log for more info. I looked around the entire system thinking the control files were incorrectly placed. The control files are not to be found. There is no alert log to look at. Can anyone tell me what may have happened to the control files and how I can get them back? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: No control files created.
Yes, All the default datafiles and database was created. David -Original Message- Sent: Tuesday, July 31, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Did you create the database? Or, just installed oracle software? Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 31, 2001 1:46 PM Hi all, I have a new install of Oracle 8.1.7 on a Compaq ES40. The install all went fine, (so it seemed) I tried starting up the db and got the error ORA-00205 Error in identifying controlfile, check alert log for more info. I looked around the entire system thinking the control files were incorrectly placed. The control files are not to be found. There is no alert log to look at. Can anyone tell me what may have happened to the control files and how I can get them back? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: Igor Neyman INET: [EMAIL PROTECTED] 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: [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: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
Call Stored procedure from another Stored procedure.
Hi all, This may have been discussed earlier, but can I call a stored procedure from another stored procedure? What access must be given to the calling SP to the called SP, and syntax from the calling SP. TIA David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
ORA-01044 error
Hi all, Can anyone tell me what this error means? I have had no luck finding info on this. ORA-01044: size 256000 of buffer bound to variable R001C005 exceeds maximum 32512 TIA David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: how to run procedure containig REF CURSOR as datatype
Tom, Is REF CURSOR only available in Version 8? I can not get REF CURSOR to compile in Version 7. David -Original Message- Sent: Tuesday, June 05, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Harvinder, change your script like this: declare io_cursor getrateschedules_pkg.t_cursor; == change the reference to the cursor declared in the package body. begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / we do this all the time for ref cursors used by VB. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, June 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Hi, What value to pass as io_cursor in the following procedureHow to run the procedures containing REF CURSOR.. create or replace package GetRateSchedules_pkg as TYPE t_cursor is REF CURSOR; procedure GetRateSchedules( temp_id_acc int,acc_cycle_id int,default_pl int,RecordDate date,temp_id_pi_type int,io_cursor in out t_cursor); end; i am getting error when i run the following code: declare TYPE t_cursor is REF CURSOR; io_cursor t_cursor; begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] 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: [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: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
PL/SQL cursor declaration
Hi all, I am getting a PLS-320 the declaration of the type of this expression is incomplete or malformed. This is ORACLE V7, PL/SQL V2.1.4. I know I am missing something but I can't see it. The select should return multiple rows to be passed into a web page. Thank in Advance David Here is the code. create or replace PACKAGE COURSE.COURSE_BULLETIN is CURSOR C1 (i_ccyy IN NUMBER) is select call_no, schl_cd, dept_cd from course.cmcmcrst where ccyy = i_ccyy and term_cd = '2' and instrl_cd = '0'; procedure COURSE_SELECT(i_ccyy IN NUMBER, rsCur IN OUT C1); end; create or replace PACKAGE BODY COURSE.COURSE_BULLETIN is procedure COURSE_SELECT(i_ccyy IN NUMBER, rsCur IN OUT C1) begin open rsCur (i_ccyy); end; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
PL/SQL Error
Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: PL/SQL Error
Here is the ASP code ccyy = 2001 set cn = server.CreateObject(adodb.connection) set cmd = server.CreateObject(adodb.command) set rs = server.CreateObject(adodb.recordset) cn.ConnectionTimeout = 120 cn.CommandTimeout=30 cn.ConnectionString=DSN=db;UID=user;Password=pwd cn.Open cmd.ActiveConnection = cn cmd.CommandText = {call course.course_bulletin.course_select({resultset 1, o_call_no, o_schl_cd, o_dept_cd})} cmd.CommandType=adCmdText cmd.Parameters.Append cmd.CreateParameter(i_ccyy, adInteger, adParamInput, , clng(ccyy)) set rs.Source = cmd rs.Open -Original Message- Sent: Wednesday, May 30, 2001 12:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I think the error is in the call to the procedure, not in the procedure itself -- the procedure looks fine at a glance. Could you post the ASP code that makes the call? Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Bartolo, David To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bartolo@USCOcc: LO.edu Fax to: Sent by: Subject: PL/SQL Error root@fatcity. com 05/30/2001 01:06 PM Please respond to ORACLE-L Hi all Can someone help me out here? I am getting this error when I try to run this PL/SQL code from an ASP page. The error manual just says to check speeling. I DID. Is there anything I am missing? The DB is V7.3 I am trying to return the resultset to the page. PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT' Here is the PL/SQL code create or replace package course.course_bulletin is TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type INDEX BY BINARY_INTEGER; TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type INDEX BY BINARY_INTEGER; TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type INDEX BY BINARY_INTEGER; PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd); end; create or replace package body course.course_bulletin as PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no, o_schl_cd OUT tbl_schl_cd, o_dept_cd OUT tbl_dept_cd) IS CURSOR c1 is SELECT call_no,schl_cd,dept_cd FROM COURSE.cmcmcrst WHERE ccyy = i_ccyy AND term_cd = '2' AND instrl_cd = '0'; crscount NUMBER DEFAULT 1; BEGIN FOR c IN c1 LOOP o_call_no(crscount) := c.call_no; o_schl_cd(crscount) := c.schl_cd; o_dept_cd(crscount) := c.dept_cd; crscount := crscount + 1; END LOOP; END; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).
Calling a script/other program from a stored procedure
Hi all, I think this thread was talked about a few days ago, but I missed it. Can anyone show me how or where to look to call a unix script or other program from a stored procedure. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] 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: [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).