Recent content by lynn_sai

HI MARCO, WE'RE ABOUT INSTALLING DELPHI VERSION 6 FOR OUR DEVELOPERS. WE'VE BEEN USING DOA 3.4.2, AND I SEE YOU HAVE NEWER VERSION 3.4.5 MY QUESTION IS HOW WE CAN GET THIS UPGRADE VERSION??? THANKS.

Hi Marco, My oracle function is: Function MyFunction Return Boolean As you can see, this function has no param, all it has to do is just to return a boolean value. This is the first time I call oracle function in delphi, and I'm using TOraclePackage to call this function, and I'm not sure...

now I solved that problem. However, I have another problem when I use CallBooleanFunctioin from TOraclePackage. My boolean function suppose to return a True boolean value; However, whenever I call: CanEdit : Boolean; CanEdit := OraclePackage1.CallBooleanFunction('myfunction') it always...

Hi I have an Oracle function CAN_UPDATE to check the user privileges, and I use TOraclePackage.CallBooleanFunction to call it; However, I have the error: " PLS-06550: identifier 'CAN_UPDATE' must be declare........" Please help... Thanks.

it was mistyped, it should be all table1 in my earlier question..... Going back to my question, I don't want to have variables in my TOracleDataset's SQL state., I want these variables to be declared and executed at run time only.......

Hi Marco, When I use the TOraDataSet with the method SetVariable and DeclareVariable, I have the followinfg message: ORA-1036: illegal variable/name number My SQL state. in TOracledataset: select * from table1 and at run time: table1.Deletevariables...

Hi Marco, I think I wasn't clearly explaining my question. What I meant was how to store CLOB field's files (files : the content of CLOB fields were save in word documents) in the same tablespace as the rest of schema data... Thanks in advance

make sure your oracledataset's variables property for :CARR_ID is selected integer.....

Hi, My Paradox tables have several formatted memo fields which I want to save into MS Word and to store in CLOB or BLOB field in Oracle database. Please tell me the whole procedure doing it. It'd be appreciated........ Thanks in advance

hi, I'm migrating application to DOA. I used to have TQuery with OnUpdateRecord events (with TUpdateKind.........) in my applications........ Is there any similar event in TOracleDataSet or OracleQuery ???????????? Thanks.

thanks everyone.....

try Fetch Params on CDS, it will be ok.....

Hi, How can I create indexes at runtime (by using oracledataset) and then sort the oracledataset using that index ???????? Thanks.......

We have several applications using Oracle client 7.3 and everything was working fine with DOA. But now we migrate them into Oracle Client 8.1.x, most of the application work fine but there is only one application keeps giving me an error message : "ORA-12162: TNS...

Hi, My code: oraclequery.sql.add('select myseq.nextval "number"') oraclequery.slq.add('from dual') works just fine in Oracle version 7 But when we migrate it into Oracle ver 8, this sequence does not work properly, it keeps giving a value 0 whenever I do insert records........ I wonder...