I can't get Collection values in OracleDataSet component.
in Oracle:
/*
create or replace type t_dummy as varray (1024) of varchar2(100); create table dummy (code number, field1 t_dummy); insert into dummy values(1, t_dummy('value1', 'value2', 'value3', 'value4')); commit; */
in delphi...
if in
orale.pas
function FindVariables(const SQL: string; IncludeDuplicates: Boolean): TStringList;
comment string:
if s[i] > #255 then Inc(wcCount);
all work
table is:
create table test1
(
n1 number,
n2 number,
n3 number,
v1 varchar2(255),
v2 varchar2(255),
v3 varchar2(255),
*** varchar2(255)
)
select is:
select
t.***
:column
from test1 t
:column - ,t.n1
if *** - english text it`s work
if *** - russian text it`s not work and...
I have a SQL :
select
:column
from :from
where
:usl1
order by :order
variale hav value but
in SQLEditor and run mode have oracle error
SubstitutedSQL show
"select
:column
from :from
where
:usl1
order by :order"
it worked on 3.4.6.4
I'm using Delphi 7 Ent
Not work tOracleLogon.HistoryWithPassword
while not coment line
" if not WithPassword then Password := '';"
in procedure THistoryItems.Add
in module OracleLogOn