Search results for query: *

Hi I'm trying to export webapps from Portal 5.1 to Portal 6, using XMLAccess. All went well, but I just notice that once I export from version 6, some new information are included in the exported XML. The info is DOMAIN=CUST... usually it's DOMAIN=REL... what happenned ? I think this is...

Ok. I changed the "CHAR" setting in the .ctl in my environment. I changed it to 200000 (to be on the safe side). Here is what I have now : Record 132867: Rejected - Error on table TTMPINTPFC. ORA-01461: can bind a LONG value only for insert into a LONG column What is the maximal value of...

It worked on your test_table here. I will test tomorrow on the real thing. :)

Got something : WHen I add the following code to Dagon's example, I reprodure the problem I have in my table : OPTIONALLY ENCLOSED BY '"' HHHEELLPP please

Sorry to tell you that, but it seems like it does not work. I checked and checked again, and here is the result : Number to load: ALL Number to skip: 0 Errors allowed: 2 Bind array: 64 rows, maximum of 65536 bytes Continuation: none specified Path used: Conventional Table...

Yup, I gave you a star allright. You deserved it! Thanks again

oups... sorry. I got the wrong log ;) It actually works ;) Big thanks to Dagon --->Star for ya!! :) Forand

Ok. Here is the latest : Looks like I'm back @ square 1.... I changed the DIRECT parameter to false, and changed my INTVTEXT definition in the .ctl to INTVTEXT "SUBSTR(:INTVTEXT,1,200)". Here is the result : Number to load: ALL Number to skip: 0 Errors allowed: 2 Bind array: 64 rows...

Ok. So i changed my sqlldr command "DIRECT=FALSE". I'm trying it right now. More to come :)

Hold on... i think it might have worked... don't know why I got this error msg, but some data has been entered in my table.

Tried that^^ but I got this error msg : SQL*Loader-417: SQL string (on column INTVTEXT) not allowed in direct path. anyone ?

So, i just paste 'INTVTEXT "SUBSTR(:INTVTEXT,1,200)"' in my .ctl file instead of my 'normal' definition of INTVTEXT ?

Hi! I'm currently using SQL*Loader to insert data into a Oracle table. Here is my sqlloader command : sqlldr / CONTROL=pfc_tmp_int_new.ctl LOG=tmp_int.log BAD=tmp_int.bad DATA=intv.dat ERRORS=2 DIRECT=TRUE>/dev/null here is my table : TABLE TTMPINTPFC ( INTCOD NUMBER, MSGIDF...

Thanks! That is exactly what I was looking for. Star for you!

hi I have 2 sets of data : Time of entry Time of exit Both data are varchar2(17), both data are something like this : 05/10/07 08:01:49 05/10/07 08:02:58 How can I find the time elapsed between "entry" and "exit"? Thanks in advance Forand

hi I have 2 sets of data : Time of entry Time of exit Both data are varchar2(17), both data are something like this : 05/10/07 08:01:49 05/10/07 08:02:58 How can I find the time elapsed between "entry" and "exit"? Thanks in advance Forand

Thanks Beilstwh and Turkbear for your help. I got it right now. 1 star each!

nailed. thanks :)

Ok DNG : I have a web page with a button in it. When a user click on it, i want the server to shell to a batch file (on the server) which will generate a web page and open it for the client. what do you think?

Hi I'm new to ASP and i need to use it to do a shell on the server-side to a batch file (.bat). How can i do that?