Trailing Space

[Charley]

Hi,

I have a probleme... ;-)

CREATE TABLE TEST
(
KEY NUMBER,
COLUMN AAAA CHAR(1),
COLUMN BBBB CHAR(1)
);

create or replace procedure Test
(
pi_Key in TEST.NUMBER%TYPE,
po_AAAA in TEST.AAAA%TYPE,
po_BBBB in TEST.BBBB%TYPE
)
is
begin
SELECT AAAA, BBBB
INTO po_AAAA, po_BBBB
FROM TEST
WHERE KEY = PI_KEY;
end;

If try the Test procedure in a "Test" window, it work. But ik you look the size of po_AAAA or po_BBBB the Length is 4000 and not 1 or 4 as their type (CHAR(1) or CHAR(4))

I precise this work in previous versions of PL/SQL and DOA.

I have this probleme also with the DOA 4.0.7 and it was a big probleme for me.

Can you help me please.

Charley

 

[Charley]

Oups...

I work with PL/Sql 7.0.2 and DOA 4.0.7

 

[Marco Kalter]

The size of the parameter is unknown, so the maximum size is used. Only the type is known.

 

[Charley]

Yes i know that but with the OracleSession.Preferences.TrimStringField := True this does not occurs ?

With the DOA 3.4.6 this work fine, i precise !

 

[Marco Kalter]

I'm not sure I understand. What exactly goes wrong in which version of which product?