Recent content by Chao

Hi Terry, Does SQL Loader treat '' as NULL? If so then this is very different from SQL statement. I will give your suggestion a try. Thanks for your feedback. CHAO

Removing the space is simply not possible due to the size of the file and the fact that blank lines appears randomly in the file. I found the solution and would like to share it with you all. Just increase the maximum # of records SQL Loader can discard in the control file. Thanks, CHAO

Hi, I am importing some data into a table from a delimited text file. Unforturnately the text file contains NULL records: ID|First Name|Last Name 1|John|Smith 2|Mary|White 3|Ken|Gray My question is how can I signal to SQL Loader to ignore any null record. Thanks for your...

Is there an approach to traverse the columns of a ref cursor to extract the column information (i.e. column name and value) in PL/SQL? I can do this with Visual Basic's recordset object. Here's VB code of what I would like to do in PL/SQL: i.e. set rs = cn.execute("select * from...

Thanks Kusch. It worked.

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

Sorry, I mean to post the quest not to reply.

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

I have a dblink from Oracle to SQL Server. I need to be able to call a SQL Server stored procedure and pass it some parameters. Does anybody have any clue how to do this?

I would like to update/insert data from Oracle to SQL Server using a Oracle stored procedure. The procedure contains an insert statement that inserts data into a SQL Server table. I run the Insert statement standalone and was able to insert the entry onto SQL Server. However, using Oracle stored...

Hi, Here is the general scope of my issue. I need to execute an arbitrary stored procedure/function. Only the name of the procedure is available and it is the result of a lookup from a table. At this point, I do not know the arguments (argument name, in or out or the data type) the arbitrary...

I think your query cannot be accomplished easily with one query. Have you try writing a stored procedure?

Here is a VB sampel: dim cn as adodb.connection dim strSQL as string ... set cn = new adodb.connection cn.open database, user, password ... cn.begintrans strSQL = "insert into XXX(a, b, c) values (1, 'test', null)" cn.execute strSQL ... cn.CommitTrans

First of all, there are 2 main categories of errors in Oracle. They are system errors and user generated error. System errors are errors generated by the system, such as no_data_found. User generated errors are raised by an application when an error condition is met. This type of error is an...

Sorry, the above solution is for Oracle. I thought I was in Oracle forum.