Woops
Sorry, sent that to the wrong address ... :) Stefan Jakobsson Programmerare Arel-Data Tele: 08-470 24 00 Fax: 08-470 24 24 -Ursprungligt meddelande- Från: Stefan Jakobsson [mailto:[EMAIL PROTECTED]] Skickat: den 15 januari 2003 07:44 Till: Multiple recipients of list ORACLE-L Ämne: HELP HELP Stefan Jakobsson Programmerare Arel-Data Tele: 08-470 24 00 Fax: 08-470 24 24 <> Stefan Jakobsson (E-mail).vcf Description: Binary data
HELP
HELP Stefan Jakobsson Programmerare Arel-Data Tele: 08-470 24 00 Fax: 08-470 24 24 <> Stefan Jakobsson (E-mail).vcf Description: Binary data
Oracle ODBC On Windows95 (Don't ask) :)
I need to setup a ODBC connection to an Oracle 8.1.7 database over TCP/IP where the Client PC's are running Windows 95 (Old clunkers) Anyone know what I need to do for this? Can I use the 7.3 ODBC drivers written for Windows95 for connection to a 8.1.7? I've never done this before and can't find any clear answers about it on Oracles website. Would be immensly gratefull for an answer of any kind, even if it is a "no-can do", then I would know that I dont have to put any more effort into this :) Thanks! Stefan Jakobsson Arel-Data [EMAIL PROTECTED] Tele: 08 - 470 24 00 Fax: 08 - 470 24 24 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson 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).
SV: Unixscript
One soultion (if we are talking about "pure" files) is to set up samba with a shared directory on the unix can, then a cron job that copies the file you are interested in at regular intervalls to the sambashare. Then you can copy the files from the samba share to your windows machine without any problems. /Stefan -Ursprungligt meddelande-Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Skickat: den 15 februari 2002 14:28Till: Multiple recipients of list ORACLE-LÄmne: Re: Unixscript Roland, I take my life in my hands, but here goes.. The script you are looking for doesn't exist per se. There are a number of variables involved in the transaction you describe (transferring a file from Unix to PC) that need to be defined before a solution can be developed. 1. Who will inititiate the transaction, the person requesting the file (user) or the file generator (developer, DBA, Sys Admin, or even perhaps the user)? 2. Is the file produced automatically (like a daily report via stored procedured for instance), or on demand, either by a systems person or by the user via some interactive process (web)? 3. What type of security is involved/required? Will the transaction take place through a firewall, over the company LAN/WAN/Intranet? How is the user allowed access/authentication into the Unix system? How is the system allowed access/authentication to the PC? These are some basic questions that need to be answered. Cron jobs using ftp or telnet are a possibility. E-Mail. Internet/Intranet delivery via any of a number of ways. The permutations are part of the challenge that keeps us employed, the investigation of the methodology and technology part of the challenge that keeps us employable David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]02/15/2002 03:53 AM PSTPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc: bcc: Subject: Unixscript Hallo,Anyone who has a good example on a unix script, which does the following:Copies files from a unix directory. to the hard drive, for instance from the directory /konto/testto the hard drive C:\tempWould appreciate this if you could help me with this.Thanks in advanceRoland--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo 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: 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).
SV: Ok... this is driving me nuts!
Good suggestion... About the only problem is that if I try to select on the package.function name, I get an error stating that I'm not allowed to perform DML on a select statement. Ad the problem with declaring a variable such as: declare x number; begin x := raknaupp.fakturanummer; end; Well, the application (written in FoxPro) that tries to use the statement goes gaga on it and doesn't recieve a value from the statement apart from the fact that the SQL-statement succeded.. This is giving me grey(er) hair! :) Oh well, thanks for the suggestions guys... I think I have to rethink the entire thing :) /Stefan > -Ursprungligt meddelande- > Från: Mercadante, Thomas F > [mailto:[EMAIL PROTECTED]] > Skickat: den 13 februari 2002 15:58 > Till: Multiple recipients of list ORACLE-L > Ämne: RE: Ok... this is driving me nuts! > > > Stefan, > > You cannot execute functions in that manner. > > You can however, do : > > select RAKNAUPP.FAKTURANUMMER from dual; > > The problem is that the function is trying to return a value > to you. When > you try and CALL it, there is no place for the value to return to. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Wednesday, February 13, 2002 9:23 AM > To: Multiple recipients of list ORACLE-L > > > > I have the following package defined > > PACKAGE RAKNAUPP AS > FUNCTION FAKTURANUMMER RETURN NUMBER; > FUNCTION MEDLEMSNUMMER RETURN NUMBER; > FUNCTION OCRNUMMER RETURN NUMBER; > FUNCTION INBETNUMMER RETURN NUMBER; > END RAKNAUPP; > > PACKAGE BODY RAKNAUPP AS > FUNCTION FAKTURANUMMER > RETURN NUMBER > IS NFAKNR NUMBER(8); > BEGIN > SELECT medlfaktnr+1 INTO NFAKNR FROM parametrar FOR UPDATE; > UPDATE parametrar SET medlfaktnr = medlfaktnr+1; > COMMIT; > RETURN (NFAKNR); > END FAKTURANUMMER; > FUNCTION OCRNUMMER > RETURN NUMBER > IS NOCRNR NUMBER(6); > BEGIN > SELECT ocrnr+1 INTO NOCRNR FROM parametrar FOR UPDATE; > UPDATE parametrar SET ocrnr = ocrnr+1; > COMMIT; > RETURN (NOCRNR); > END OCRNUMMER; > FUNCTION MEDLEMSNUMMER > RETURN NUMBER > IS NMEDNR NUMBER(6); > BEGIN > SELECT medlnr+1 INTO NMEDNR FROM parametrar FOR UPDATE; > UPDATE parametrar SET medlnr = medlnr+1; > COMMIT; > RETURN (NMEDNR); > END MEDLEMSNUMMER; > FUNCTION INBETNUMMER > RETURN NUMBER > IS NINBNR NUMBER(6); > BEGIN > SELECT inbetnr+1 INTO NINBNR FROM parametrar FOR UPDATE; > UPDATE parametrar SET inbetnr = inbetnr+1; > COMMIT; > RETURN (NINBNR); > END INBETNUMMER; > END RAKNAUPP; > > It works fine, except when I try to run it with call: > > call RAKNAUPP.FAKTURANUMMER; > > Then I get: > > ORA-06576: not a valid function or procedure name > call 'raknaupp.fakturanummer' > > And I'm about at my wits end here... I can't for my life > figure out why this > isn't working as it is suposed to! > > Could someone please figure out what I am doing wrong? > > Stefan Jakobsson > [EMAIL PROTECTED] > Telefon: 08-470 24 00 > Telefax: 08-470 24 24 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stefan Jakobsson > 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: Ste
Ok... this is driving me nuts!
I have the following package defined PACKAGE RAKNAUPP AS FUNCTION FAKTURANUMMER RETURN NUMBER; FUNCTION MEDLEMSNUMMER RETURN NUMBER; FUNCTION OCRNUMMER RETURN NUMBER; FUNCTION INBETNUMMER RETURN NUMBER; END RAKNAUPP; PACKAGE BODY RAKNAUPP AS FUNCTION FAKTURANUMMER RETURN NUMBER IS NFAKNR NUMBER(8); BEGIN SELECT medlfaktnr+1 INTO NFAKNR FROM parametrar FOR UPDATE; UPDATE parametrar SET medlfaktnr = medlfaktnr+1; COMMIT; RETURN (NFAKNR); END FAKTURANUMMER; FUNCTION OCRNUMMER RETURN NUMBER IS NOCRNR NUMBER(6); BEGIN SELECT ocrnr+1 INTO NOCRNR FROM parametrar FOR UPDATE; UPDATE parametrar SET ocrnr = ocrnr+1; COMMIT; RETURN (NOCRNR); END OCRNUMMER; FUNCTION MEDLEMSNUMMER RETURN NUMBER IS NMEDNR NUMBER(6); BEGIN SELECT medlnr+1 INTO NMEDNR FROM parametrar FOR UPDATE; UPDATE parametrar SET medlnr = medlnr+1; COMMIT; RETURN (NMEDNR); END MEDLEMSNUMMER; FUNCTION INBETNUMMER RETURN NUMBER IS NINBNR NUMBER(6); BEGIN SELECT inbetnr+1 INTO NINBNR FROM parametrar FOR UPDATE; UPDATE parametrar SET inbetnr = inbetnr+1; COMMIT; RETURN (NINBNR); END INBETNUMMER; END RAKNAUPP; It works fine, except when I try to run it with call: call RAKNAUPP.FAKTURANUMMER; Then I get: ORA-06576: not a valid function or procedure name call 'raknaupp.fakturanummer' And I'm about at my wits end here... I can't for my life figure out why this isn't working as it is suposed to! Could someone please figure out what I am doing wrong????? Stefan Jakobsson [EMAIL PROTECTED] Telefon: 08-470 24 00 Telefax: 08-470 24 24 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson 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).
Stored Procedures
Well, I finally got permissions to use stored procedures in one of our projects. Problem is, I'm not all that "butch" when it comes to SP's, so, the question is. Do any of you have any links to good tutorials that shows how to best utilize them? Would like to see some examples on what you can do with them. In our case they will be very simple. Would be gratefull for any pointers :) Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson 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).
SV: Hmmmmm
There are more rows in that table. It's one that we use for storing sequential numbers we use... like invoice numbers, membership numbers etcetc So we have to lock row when using it, so noone else uses the same number when we add a new member or create a new invoice... But good advice tho, and I would have used lock on it if not for the fact that we have to use row locking on it... /Stefan > -Ursprungligt meddelande- > Från: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Skickat: den 25 januari 2002 15:00 > Till: Multiple recipients of list ORACLE-L > Ämne: Re: Hm > > > is there only one row in that table? if so, you can lock the table > itself. > > try it without the nowait... > > > > --- Stefan Jakobsson <[EMAIL PROTECTED]> wrote: > > Having a small problem I need some help with... > > > > The problem is trying to lock a row on a parameter table for an > > application. > > > > The thing we need to do is following: > > > > Read the value in one row. LOCK that row for other users, increase > > the value > > with one > > update the row with the new value and release if for access to other > > users. > > > > We are trying to use the following SQL statement. > > > > SELECT medlnr FROM parametrar FOR UPDATE OF medlnr NOWAIT; > > > > But the thing is that when we try, anyone can head on in and select > > the same > > value > > and even make an update of that row... > > > > What am I missing here? > > > > Regards, > > Stefan Jakobsson > > Programmer > > Arel-Data > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Stefan Jakobsson > > 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). > > > __ > Do You Yahoo!? > Great stuff seeking new owners in Yahoo! Auctions! > http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Stefan Jakobsson 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).
Hmmmmm
Having a small problem I need some help with... The problem is trying to lock a row on a parameter table for an application. The thing we need to do is following: Read the value in one row. LOCK that row for other users, increase the value with one update the row with the new value and release if for access to other users. We are trying to use the following SQL statement. SELECT medlnr FROM parametrar FOR UPDATE OF medlnr NOWAIT; But the thing is that when we try, anyone can head on in and select the same value and even make an update of that row... What am I missing here? Regards, Stefan Jakobsson Programmer Arel-Data -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jakobsson 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).
