Recent content by Krzysztof

Hi, To IngoBfN: Thank you for your solution, but it provides to the same error - ORA-22275. To Marco Kalter: Many thanks for your engagement with my problem. Unfortunatelly, I am not interested to put this blob into the table... I want only pass it as parameter to procedure. In this...

Thank you for your answer, 1. I can't upgrade to Net 8.1 - it does not depend on me :( 2. I tried to implement your second option... so... I added procedure to BLOB_TOOLS package : procedure INITBLOB(P_BLOB out blob) is begin P_BLOB := EMPTY_BLOB(); end; I use them to initialize my...

Hi, I am using: DOA 4.0.7.1 OCI: version 8.0 Oracle Database 9i I have OracleQuery with following SQL begin BLOB_TOOLS.BLOB_TEST(:P_ROWID,:P_BLOB); end; :P_ROWID is a string, but :P_BLOB is a blob parameter. I try set this BLOB parameter in the following manner: LOB :=...

Exactly

I have package spec. create or replace package INFO_TMP as -- Package description -- Procedure description procedure ALL_INFO; end; Output from PLSQLDoc: USER@ALIAS index Package INFO_TMP -------------------------------------------------------------------------------- Program units...

My SQL Property (TStrings type) is written in multiline way, for example: 1. select * 2. from dual 3. where 12 But when I analyze it in my program, SQL.Count has '1' value and SQL statement is visible as one line statement. Each newlines are seen ("replaced") as space. In my example 1. select *...