Question about PL/SQL

Hallo, all you experts Does anyone have any good example of procedure, that does a select statement from the database and afterwards automatically save this resultat to an excel file.? Sincerely Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Utl_file question

Hallo all experts, I have written this procedure but get this error message. What is wrong? 1 DECLARE 2 emp_data UTL_FILE.FILE_TYPE; 3 BEGIN 4 emp_data := UTL_FILE.FOPEN ('c:\', 'pelle.xls', 'W'); 5 FOR BAKERS IN ( 6 select AVDNR, DATO 7 FROM BAKERS) LOOP 8

Reading a textfile into the database

Hallo, you all experts and thanks for all your advices about my utl-file ... Here is another: Does any one have a good example of pl/sqlscript which reads a text-file into the database? Thanks a lot to anyone who canhelp me with this. Roland Skldblom -- Please see the official ORACLE-L

Slow database

Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day,

If-statement

Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this

DBMS_OUTPUT.PUT_LINE

Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Insert without telling column names

Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Updating table2 from table1

Thanks for all your advices to me. How can I write a procedure, that does a selection from table a and then puts that data into table nr 2. In the new fields in table2 I am supposed to put for instance sums from table1 of certain fields. Roland S -- Please see the official ORACLE-L FAQ:

Make a character format from number format

How can I make a character format from a number format in an insert statement? For instance insert into table_name values(10, 1960); where 1960 is supposed to be put in the column, which is in character datatype. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Data into another table

How can I create a select statement from table1 including some division or multiplication , and then include the result into table2. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Reverse engineering

Hallo, I am doing a reverse engineer of the Oracle database, which means that I am loading the database into the program Erwin. When it i simported into erwin I willbe able to seeall the relations, tables, views etc of the database. But when i am doing the reverse engineer I get many error

olap?

Hallo, Can anyone tell me: What is OLAP and how does it work, a short description, thanks. Roland Skldblom -- 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,

Is there any Access user group?

-- 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

Errors in Oracle

Anyone who can give me a link to a website, where I can see the description of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the error is about and how to fix it. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Slow database

We are running an oracle database 8i, we have several Ms Access applications connected by ODBC to this database. The database is very complex ,in total about 300 tables and of course PL/SQL procedures We also have many different schemas in this database. But we have a big problem, when we

sqlloader

Hallo, Can anyone tell me how to get sqlloader, how can I try and find out to see if I have it already installed ? How do i Install it? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Which CD?

On which installation CD can I find sqlloader setup? Roland Skldblom -- 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

Help with sqlloader

Hi folks, (See attached file: mondaytest.txt)(See attached file: describetable.txt) Can anyone help me to write a ctl-file, for instance called test.ctl, to use when i use sqlloader to import a textfile into the oracle database? I am including two files here, which you might need. Thanks in

Check the constraints

Hallo Anyoine know about any program that can check all the constraints after the database is designed? Roland Skldblom -- 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

PL/SQL-question

Hi, I have imported a text-file into a table in the database. Now I find that there are many bad things in some fields, for instance there is a ? instead of the value 0. Can anyone give me a good example on a procedure that loops through a table and if found a ? in some fields, replace it

Left position

Can anyone tell me which function to use if I want a string to be left positioned, not centre positioned ? Roland S -- 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

Question about PL/SQL-Unix

How can I create a file, and the send it through mailsystem imediately to a mail recipient.We use Lotus Notes mailsystem. Any good example? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Example of pl/sql

Anyone who has a good example on a procedure that first deletes all the records in a table and then does an insert? Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Sqlloader

How can I in a sqlloader, the control file replace a ? with a 0 at the same as it i sloading the data into the database? The ? could be anywhere in any field. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Acces forum

I would like to know if there is a website for access developing where I can ask questios? Roland Skldblom -- 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,

Sqlloader

How can I within sqllldr call a pl/sql-procedure which deletes all rows from a table? Roland S -- 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

PL/SQL-delete, insert

Can anyone give me an example of an pl/sql-procedure, that first delete rows from a table and afterwards insert values in that table. This should be in the same procedure. Thanks for the help I can get on this, a good example. Roland Skldblom -- Please see the official ORACLE-L FAQ:

PL/SQL-if-statement

How can I change this pl/sql code, in the while-statement maybe so that if the field OWNER_NO is NULL, then it should be written six characters? The code looks like this: "IF recCursor.OWNER_NO is null then vOWNER_NO := '00'; else v_OWNER_NO:= to_char(recCursor.OWNER_NO); WHILE

Column name

Can I use the same column name in the same database and in the same schema? Could this cause me lots of trouble? Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Insert from a table to another

Any one whom can give me a good advice, on a pl/sql procedure, that delete data from table a, then runs a query from table b and and that insert this query into table a. Pleas help me with a good example. Thanks Roland Sköldblom -- Please see the official ORACLE-L FAQ:

Invalid number of arguments

Hallo, I have a procedur, and when i compile it I get the erro rmessage Invalid number of arguments in call... It stops at the line: vDELIVERY_STOP_DATE:= lpad(nvl(recCursor.DELIVERY_STOP_DATE,0),8,'0'); The datatype declaration in pl/sql is varchar2 for the field but in the database it is

PL/SQL-procedures

How can I write procedure which runs 3 different subprocedures.? Roland Sköldblom -- 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

Ftp

How can I write a PL/SQL procedur that connects to a ftp server and then gets a file from the unixsystem? Give an example, please. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Textfile into oracle

Hallo, I have this excelfile. Is it possible to import this into an oracle table. This file is supposed to be located on unix machine from the beginning and the import into an oracle table would be done from unix. How should I name the fields in the oracle table. I mean should I use the 9-10

Ang: Re: Textfile into oracle

Could anyone please give me an example on how the sqlloader script would look like , How many fields would it be,? I cant find anything ofthis in themanual. I have 100 fields in the excel file but only 9-10 field names... Thanks in advance Roland Alexandre Gorbatchev [EMAIL

Sql loader question

Hallo I am running this script but gets this errormessage: Why is it so? I get the errormessage The system cannot find the file specified.(I:dvh\tuppy.txt) but this file really exists: What is wrong. I include the textfile and also the ctl file. (See attached file: nielsen.ctl)(See attached

Question about sql loader - help

Hallo all you gurus, I have a question: Is it possible that every time the sql loader script runs change the field names to the field names specified in the file to be loaded.: The field names should be different dates. The next time the script sqlloader run sit will be a new field name,

Pl/Sql renaming columns

Hallo, Anyone who has any good hint on how to write pl/sql if i wantto chang ethe name of the fields everytime the procedur runs? The field names should be 1-JULI-2002 the first time the procedur runs, the next time the procedur runs the name of procedur should be 1-AUG-2002 etc. Please help

Sql query

Hallo, anyone whom can give me an example on how to pick out field id and name from table one and get only the id's that exists in table one doesnt exist in table2. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

SQLLOADER - please help

Hallo, anyone whom can help me with this: I am running sqllodaer and gets this errormessage in the log: Record 18729: Rejected - Error on table RIK2.IMP_NIELSEN, column MONTH_DISTR_W Column not found before end of logical record (use TRAILING NULLCOLS) ORA-01631: max # extents (20) reached in

Unix - scheduling

Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

Count rows in textfile

Anyone whom has a good example on how to check how many rows (without opening the file) does a text file consists of? What is the command? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Records in pl/sql

Hallo all you experts, Can someone tell me when to use Records in a pl/sql procedure and why I should use them? Can I use PL/SQL records in all procedures i write? Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

DBMS_JOB

Hallo, How can I schedule a pl/sql job, I want this to happen: Every Sunday at 11 pm I want to do an insert into a table. How shoudl I write the code in the DBMS_JOB satement.? Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]

Unix-script

Hallo, Can anyone give me an eaxmple of a iunix script, which checks if the file in unixsystem exists and if it does then it runs th esqlloader script, which loads data into a database table.? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Unix-script

Hallo Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled? Roland

Uniix-script-help

Hallo, Anyone whom has a good example on a unix-script that does this: I want it to run sqlloader script, which loads data into a table in the database and also make an insert from this table into anothertable? I wantthis to be scheduled every day. Also with a check if the file exists in the

Sqlldr-help

Hallo, Can anyone give me an example on a control.file for th esql ldr that does the following: Truncate table X inthe database Loads data into table X Makes an insert from that table into another table in the database. And of course commit statement afterwards Thanks in advance Roland S

Choose different variables

Hallo, Can anyone tell me how I can send different variables into a procedure, depending on which action should take place? Please give me an example. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

Query from access to oracle

Hallo, Anyone who can help me, I have this query in Ms Access: How should I write this sql statement in oracle. SELECT RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, Sum(BRT.BRTOMS_DAG.ANT) AS ANT, Sum(BRT.BRTOMS_DAG.UTVERDI) AS UTVERDI, BRT.BRTOMS_DAG.DATO,

DBMS_JOB statement

Hallo, Can anyone tell me a example on a script which does the following: - Starts a job, a pl/sql-procedur, at 6 pm every day, - If something goes wrong then I want information to be logged. (Should I include the logging in the pl/sql procedur) Thanks in advance Roland S --

Ftp from Oracle

Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Make first character Versal

Hallo, I know this question sound a bit simple, but can anyone give me a select statement which make the first character of the word in a field Would appreciate very much. I have checked the manual but cant get it right. I am starting with this sql statement: select (substr (namn,0,1)) from

Ang: Re: Make first character Versal

I found out what was wrong: wanted to do an update too... update test set test = upper(substr(namn,1,1)) || substr(namn,2) then my update worked Roland S Jan Pruner [EMAIL PROTECTED]@fatcity.com den 2002-03-27 04:23 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL

Trigger question

Hallo, anyone who can please helpme with a trigger script that does the following: I want this script to run when I have updated a field in a table. update test set namn = upper(substr(namn,1,1) || substr(namn),2) I want this trigger to fire only for the selected record(row), that is going

Trigger question

Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been

Pl/SQL debug

Hallo, I am trying to insert things into the table PRISREGISTER_KOPIA_WED but why doesnt the insert statement work. It says Missing expression when the insertstatement runs and when i look at the sql code which is trying to be run to insertinto the table it says just missing expression and it

PL/SQL again

I sent the wrong pl/sql code in last message. I want the field BORTTAGS_FLAGG to be inserted in prisregister_kopia_wed. (See attached file: regicarol.txt) What is missing? Thanks in advance Roland S regicarol.txt Description: Text - character set unknown

Ang: RE: Send mail from pl/sql

I am using Notes mail system Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-05 01:18 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Which mail client are you looking it for. If it is for

Copy tables and indexes etc from one db to another

Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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

Pl/SQL code help

Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement, whatis wrong with this? It get the erromressage: LS-00103: Encountered the symbol ||AvdNr|| when expecting one of the

PL/SQL help - need some quick help

Hallo, I have some trouble to get this pl/sql code right. Anyone whpom could help me with this. It is important. Hallo, I have some trouble with this pl/sql procedure. I would like that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in the if statement,

Ang: RE: Pl/SQL code help

But when I have fixed that error and then have the then statement put before the lvsql statement I get this errormessage: What does that mean? How to fix it? PLS-00103: Encountered the symbol THEN when expecting one of the following: ( - + mod null an identifier a double-quoted

Pl/sql question - if statement

anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol ||AvdNr|| when expecting one of the following: . ( * @ % = - + / at in mod not rem then an exponent (**) or != or ~= = = and or like betwe when i run

Ang: RE: Pl/sql question - if statement

Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol BORTTAGS_FLAGG when expecting one of the following: . ( * @ % = - + / at in mod not rem then an exponent (**) or != or ~= = = and or like I reallydont see what the error is:

Utl_file

Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- Please

Unix script

Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log

Unix - need some help

Hallo, I have this unix script, please tell me how to change it so it also does the following: (See attached file: laddabilbo.sh) counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). IThis log

Unix help

I have this unix script, please tell me how to change it so it also does the following: counts the time between start time and end time of the process(I mean time difference between Jobb startat(Job started) and Job Klart(Job Finished). loadbilbo.sh: #!/bin/sh . /usr/bin/orasetup.sh .

Import excelfile into Oracle table

Hallo, anyone who can give me a good example of pl/sql code, which does the folllowing: Import an excelfile into a table. (I know I can use sqlloader(which I have used several times) but i would like to make a call to that pl/sql procedure from MsAccess. Thanks in advance Roland --

Ang: Re:Import excelfile into Oracle table

Ok, thanks can you give me a good example on how to write the pl/sql code? Thanks in advance. Roland [EMAIL PROTECTED]@fatcity.com den 2002-04-18 01:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia:

Send mail from PL/SQL

Hallo, anyone whom can help me. I would like this code to send email to two recipients, what is missing? Thanks for all help I can get. PROCEDURE sendmailtestny2( inRecipient1 IN VARCHAR2, inRecipient2 in VARCHAR2,

Ang: RE: Send mail from PL/SQL

it helped with CC: Thanks /Roland Abdul Aleem [EMAIL PROTECTED]@fatcity.com den 2002-04-19 03:48 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: In Outlook, when I put two addresses in TO or CC or BCC

Constraints

Hallo, I am trying to run this script, ALTER TABLE PBK.K1 ADD CONSTRAINT idx_rollson PRIMARY KEY (BUTIKS_NR) but gets the erormessage ORA-02437: cannot validate (PBK.IDX_ROLLSON) - primary key violated what can I do to solve this? Please help me. Wouldnt it be enough to have unique values

Cronjob

Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland -- 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

Cronjob

Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Ms Access user forum

Hallo, any one whom knows how where to find a good MsAccess user forum where I can ask questions? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

pl/sql

Hallo, I have a package which includes 5 different procedures. I would like an exception which tells me an error message if any of the procedures fail. So if procedure 1 fails I would get an error message or if procedure number 2 would fail, or proc number 3 e tc then I would get an error

Oracle - Access

Hallo, anyone who has a good hint on this: I have an appplication which goes against Oracle and when I am inthe application and run VBA code which connects to linked tables everything works fine. But when I have an icon on the desktop and runs that icon as shortcut then I get error messagelike

PL/SQL problems

Hallo, I would like to know how to solve this problem: When this procedure runs, which makes an insert into table pbk.prisregister, it inserts the same value in field substitut where there exists a substitut. Please help me with this? It should be null in that field in case thre is a

Enterprisemanager?

Hallo, Does anyone know if there is a graphic interface in Oracle, which you can use to move data betwen tables and also to schedule tasks? Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network

Ang: Testing

It is [EMAIL PROTECTED]@fatcity.com den 2001-11-30 10:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Testing to see if the server is working properly. Jared -- Please see the official ORACLE-L

Listener

Hallo, Can anybody tell me simply how the listener works? Thanks in advance Roland S -- 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--

Ang: SQL Loader Commit Point?

Well, you can runt the sqllodader again and then include this line after the name ofthe control file. log = C:\temp\error.log and that creates a logfile where you can see what has happened. The problem you are having can be caused by invalid length of the datafield in the database, or you

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

Update query

Hallo, How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B) Please give me an example of a sql statementö. Thanks in advance Roland -- Please see the official ORACLE-L

ODBC CALL Failed

Hallo, I am running an Access application with connection to Oracle. But when I run an access procedure I get the errormessage ODBC Call Failed. This procedure has worked fine. last week but now I get this erormessage. All procedures in oracle ar e valid. What could have happen? The ODBC

Unix - script

Hallo, I would like to have an example of a unix script, which does the following: copy some files from directory /prod/sas/data located at hardy.(which is a computer) to the other database hakon. Is it possible to do this. Please help me quick. Thanks in advance Roland S -- Please see

Ang: RE: Unix - script

So I have to use the ip-addresses? I cant use the name of the computer, for instance hakon5. Thanks in advance Roland Gogala, Mladen [EMAIL PROTECTED]@fatcity.com den 2002-01-09 07:11 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list

Unix - copyscript

Hallo, Can anyone tell me why I get this errormessage when I run this script. I know that there are files in the directory prod/sas/data/bilbo/indata Files that exists in that directory are for example customer.txt, cars.txt. I want to copy those files. But it doesnt sem to find them. The

Unix question

Hallo, why do I get the error message No such file or directory. when I try to run unix script loadfiles.sh which is located in the directory /konto/tmp. This file, loadfiles.sh really exists in that directory. Thanks in advance Roland -- Please see the official ORACLE-L FAQ:

Sql query

How can I write a select statement, which picks up a field in table1, that doesnt exist in table2. Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Sql query!!

Hallo, Will this query work if I want to pick out the field id from nisse1, and that field doesnt hgave a value in nisse2. If it doesnt work please help me. select nisse1.NAMn, nisse1.id from nisse1, nisse2 where nisse1.id= nisse2.idn(+) and nisse1.namn = nisse2.name Thanks in advance

Ang: Re: Sql query!!

please explain i tried that but didntget it to work please give me an example [EMAIL PROTECTED]@fatcity.com den 2002-01-21 05:30 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: You may also need

Ftp command

Hallo, anyone whom can tell me how to write the ftp command if I want to receive all files in the unix directory to the hard drive without to need reply yes for each file. using the command mget I suppose but ar ethere any options I might use. The same question if i want to copy files from

Ang: Re: How can I tell if a procedure/package is running?

Can anyone give me a good example on how this works? Thanks in advance Roland Connor McDonald [EMAIL PROTECTED]@fatcity.com den 2001-10-25 01:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: I

From Access to Oracleprocedure

Anyone who can help me with this query? I have a Microsoft routin, whic calls oracle procedure in database servername, which have a databaselink to other databases(located on computers with Linux system).That procedure is supposed to pick up data from tables which exist in the other

Unix - errorlog

Hallo, How can I change this script so if the PL/SQL procedure konto.fillbilbotables.anrop;doesnt start for some reason, then I want a logfile to be created on the form: 2002-02-23starterror.log. The message in that logfile could be for instance The procedure didnt start today, some problems

PL/SQL procedure - error

Hallo, anyone who can help me with a pl/sql procedure that I have four procedures that will run one after one: in an error table logs the procedurename, the start time of the procedure and the end time of the procedure.the number of rows inserted(there are insertstatements in the procedures),

Ang: Re: PL/SQL procedure - error

Thanks, and can you please tell me how to get hold of the time when the procedures starts and finishes.? Thanks in advance. Roland Pullikol Kumar [EMAIL PROTECTED]@fatcity.com den 2002-01-22 04:40 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple

  1   2   3   >