Recent content by Ralf

Wow, great! Just what I was looking for. Thanks for the quick response!

Following situation in my application server: Client sends SQL to server (through Asta-components). On Server a TOracleDataSet is created that executes the SQL. After all rows have been collected, the result is sent to the client. The problem arises when there are many (>10.000) rows as a...

Are there any examples of default values that do not work correctly? We assume it was not the strings and integers that made the translation difficult.

Hi, While generating an Oracle package it came to our notice that the parameters in the generated procedure and function do not get generated with the default value specified in the Oracle procedure. The code responsible for this has been disabled in the source code, with a comment that...

But using the objectname 'bindparam_table' from stored procedures, etc in schema A does work without the prefix! Isn't that kind of the same situation??

When I try to create a TOracleObject with a type-name 'bindparam_table' that remains in another schema I get: object 'bindparam_table' does not exist. Session logs in to schema A and type exists in schema B. And we created a public synonym in schema A for that type and a grant execute from...

Sorry, made a mistake in my test program. Now it works great! Thanks Worad for the example!

Ooops... Read following post.

myTableType looks like whatever is going to work! I don't care what type it is. Maybe my problem isn't clear... I want to use a TOracleDataset in which I put SQL that contains an in-struct and in which the in-part is a variable. So something like: 'select * from table where id in (:test)'...

And how does my delphi-code look like???

So I want an equivalent in Delphi of the following in PL/SQL: create or replace function table_select_test return integer is lvDeleted myTableType := myTableType(0, 1); lvCount integer; begin select count(*) into lvCount from receiver where deleted in (select * from...

But if I want to do this with a parameter. A table-parameter of something like that (not a string/function combination). Is that possible or not?

The target is to speed up queries. Previously we replaced markers in the SQL on the client side. So every query has to be evaluated by Oracle (explain plan etc). Therefor we want to use as much parameters as possible, making it possible for oracle to use the same explain plan. The suggestion by...

i hope this can be done in another way. this one is very slow. i think it can be done with a TOracleObject, but i don't know how.

Hello, I want to use a query like: select * from table where id in (1,2,3) but then with a parameter for the in-set. select * from table where id in (:test) or select * from table where id in :test how do i assign the variable? can you give me a sample? do i have to use a TOracleObject?