How to read the contents of a in a file or delphi memo conponent ?

[Henri GP]

Hello,

Oracle 10g EX (at home), Pl/sql developer 7.0.1.1066 / Delphi 7
I try to make my first plugin with Delphi 7
I use parameterized queries in a SQL window (large numbers like this, always parameterized)

the result is always a ,

I want to write this to a file or even better in a Memo, because I have to send it on a remote server via SFTP, after doing some controls

How to read the contents of the ?

Is it olso possible to read the request once performed by PL/SQL
If yes, how ?

Thanks,
Henry

the request from pl/sql menu/special copy/delphi : =

'select do.donnees' + # 13 # 10 +
                        'From quarc.crpdi di, quarc.crpdidonnees do' + # 13 # 10 +
                        'Where di.nommodele & <name="nom like the courrier" type="string" ifempty="%%" hint="Entrez name "default="cr_auto_prel">' + # 13 # 10 +
                        'And do.id di.iddonnees =' + # 13 # 10 +
                        'And rownum <& <name="nb_ligne" type="integer" ifempty="%" default="10">' + # 13 # 10 +
                        'And di.statut = & <name="Statut" type="integer" ifempty="5" default="15" hint="Statut of demande">' + # 13 # 10 +
                        'Order by di.datedi desc';

 

[Marco Kalter]

Is this a CLOB or a LONG field? How do you retrieve the value?

 

[Henri GP]

Hello

It's definitely a long, as shows the query if I want to duplicate this table :

create table quarc.crpdidonnees
(
ID NUMBER not null,
IDUTLQQO NUMBER not null,
DTMAJQQO DATE not null,
LONG DATA
)

I read the data with IDE_ResultGridCell (2, 1)

Thanks,
Henry

 

[Marco Kalter]

For long cell values this will indeed return the text you mentioned. We'll enhance this for the next release.

 

[Henri GP]

Hello
So no way to catch this and paste it somewhere, it will be enough for me,

My second question:

Is it possible to read the contents of the sql window once is performed by pl/sql
then, I can redirect it to a SQL_Execute (who work well also for me)
It'll be fine too

Thanks
Henri

 

[Marco Kalter]

The IDE_GetText function will return the text of the current window.

 

[Henri GP]

Hello

Ok, but it's still before interpretation,
Is there something after replacing the variables, like debugger ?

Otherwise thanks for all
Henri

 

[Marco Kalter]

No, this information is not available to a Plug-In.