Recent content by helmis

In the upcoming 4.0 release the TOracleDataSet can be instructed to close all cursors when no longer needed, and you can even disconnect the session and keep the result set. How to do that ?

hi i must use this procedure from oracle create table TESTER ( FIRST_NAME VARCHAR2(250), LAST_NAME VARCHAR2(250), COMPANY VARCHAR2(250) ); / create or replace package tester1 is TYPE sample_record is RECORD( NAMES VARCHAR2(24), LASTS VARCHAR2(250), COUNTRY VARCHAR2(20))...

i find it in the help of DOA Using a cursor variable as a TOracleQuery Because a cursor variable is equivalent to a TOracleQuery with a select statement, DOA implements the cursor variable type as a TOracleQuery. To use a cursor variable, you need at least two TOracleQuery components: one...

Thanks. excuse my bad english :( I use Doa & develop PLSQL. the question is when I have a cursor as variable in Delphi and that I must send the cursor as parameter to a procedure oracle. what should I declare in the stored procedure as a parameter input to receive the delphi cursor. if...

Hello the following procedure must receive a cursor in entry parameter and store it in a table named Person. CREATE TABLE Person ( FIRST_NAME VARCHAR2(250), LAST_NAME VARCHAR2(250), COMPANY VARCHAR2(250) ) type tcur is ref cursor; procedure so_p_save_Personne(grd_cur in...

example In oracle -- Create table create table Person ( Name varchar2(10), Country varchar2(10) ) ; //// create table Cursus ( year number, job varchar2(20), name varchar2(10) ); foreign key (NAME) Person (NAME) /// in Delphi Tperson = class Name : string Country ...

Hi How to send a (cursor) as (IN parametre) from an Toracledataset ? example : PROCEDURE TEST (Tcur IN OUT Tcur); Thanks

from multiple tables. The cursor in output parameter for the procedure, which is like open cur for select fieldnames from tablenames The grid is showing correct data, but when i am changing the data on the grid and saving , it is throwing an error saying, updating table property is required for...

we've many development projects in pl/sql (oracle) and we need to have all the objects versioned in a control version system. is PL/SQL Developer IDE support or have any subversion Plugin ? Thanks

Hi how can i use a OracleNavigator with OracleDataSet because add & insert and delete Button are not enabled. OracleDataSet can be used in insert & update mode through a tdatasource ? thanks

How to recover a out var of a stored function in a oracle database. FUNCTION ALICE_DATA( NAME IN VARCHAR2(25),NEW_NAME OUT VARCHAR2(25)) RETURN VARCHAR2 . I want to recover NEW_NAME in Delphi, for that i declare a varible in a oracledataset & i call the proceddure, but the result of...