Recent content by Devil

Thank's.

Not working. Give me example please? All variants return not logged on. ORA-12154. TNS- resolve name not exists return @tt@ora, because sid database start from first special character @(@tt@ora) In Open PLSQL Developer, File -> New -> Command Window SQL> connect scott/sc@@tt@ora Not logged...

Hi, For exemple, I have next connection information: scott/sc@tt@ora In password used @ When I pass this string in a function ... DecodeConnectString('scott/sc@tt@ora', Username, Password, Database, ConnectAs); ... that takes place not faithful treatment of this string. username: scott...

Opps, I'm sorry, It's work fine Maby I copy not correctly working query text in to Delphi code. Thanks

When I'm execute hierarchical query [START WITH condition] CONNECT BY condition and implement order by clause with siblings: order siblings by I get error ora-00936: missing expression. DOA is support for order siblings by ? What you think Marco?

Thanks. As variant I can use new subst variable &sv_owner_table: update &sv_owner_table set depno = 10 where emp_id = 1;

As a variant of decision of problem - to put a blank before a point, but it is the not best decision: --type_script = before_script update &sv_owner .&sv_table set depno = 10 where emp_id = 1;

Hi, I'm using DOA 4.0.6.1. TOracleScript.Text has a next value: /*operation_id = 30*/ DEFINE sv_owner = 'scott' DEFINE sv_table = 'emp' ... --type_script = before_script update &sv_owner.&sv_table set depno = 10 where emp_id = 1; When I execute this script(OracleScript.Execute), get...

Thanks

And, do you have any idea when WITH feature will be included in your next release?

I'm using DOA Version 4.0.6.1 (August 23, 2004) In my scripts using subquery factoring clause: WITH query_name AS ( subquery ) [, query_name AS ( subquery ) ]... for example: OracleScript.Lines.Text := WITH dept_costs AS ( SELECT department_name, SUM(salary) dept_total FROM...

Oh, I'm sorry this problem on the server, it's will be very-very load in this time :-).

But when ReadBuffer = 100 query executed only 5-6 seconds. 00:48.099 00:03.045 Query.Execute (100 records processed) 00:51.614 00:00.742 Query.Next for up to 100 records (100 records processed) 00:52.866 00:00.842 Query.Next for up to 100 records (100 records processed) 00:54.669 00:00.441...

Why my query executed very slow? I fetch by 25 records. The total time query executed is approximate 213 seconds. But the in plsql developer or toad all records fetched by 3-6 seconds DOA 4.0.6.1 Server 10.2.0.2.0 Client 9.2.0.1.0 TOracleDataSet properties: Unidirectional = True...

It's work successfully work too. For free temporary CLOB object i do next: var LOB: TLOBLocator; begin LOB := TLOBLocator.Create(MigratorSession, otClob);//CreateTemporary(MigratorSession, otCLOB, False); try //Create temporary CLOB object and fill this FQuery.SQL.Text :=...