Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yassinemannai

    DBMS_SQL

    hi friends, can you send me a package DBMS_SQL.pll via mail yacine.mannai@irsit.rnrt.tn or give me address site to download this package many thanks
  2. yassinemannai

    REF Cursor

    hi, please read this code procedure proc(tname varchar2,colnom varchar2) is cursor cur is select colnom from tname; begin ... end; the compiler generate error; procedure proc1(tname varchar2,colnom varchar2) is type curseur is REF CURSOR; cur curseur; begin open cur for select colnom from...
  3. yassinemannai

    build link to other data base

    HI karluk , thanks for your help, the link with other oracle db succeeded bye
  4. yassinemannai

    build link to MS ACCESS data base

    HI, I build a link to other Oracle database and select data from table now i want to connect to MS ACCESS DB with LINK ( create database link ): can i build a link with a MS ACCESS DATA BASE VIA ODBC please help me.
  5. yassinemannai

    build link to other data base

    hi, I have two Oracle Server ( A and B ) I create table test in B. I logged to A; I create database link to B. create databse link link_127 connect to system identified by manager using 'bibl'; (bibl is in tnsnames.ora ) I try to select data from test ( select * from test@link_127 ) the system...
  6. yassinemannai

    Create database link

    hi, I have an Oracle data base (A) and other oracle db ( B) I want to link A to B with: create database link link_127 to system identified by manager using 'bib'( bib is in tnsnames.ora ) the link is created. i have a table in B ( test). I try this command( I am logged in A) select * from...
  7. yassinemannai

    PL/SQL TABLE with EXEC_SQL.DEFINE_COLUMN

    Hi, Please read this code : declare connection_id EXEC_SQL.CONNTYPE; cursor_number EXEC_SQL.CURSTYPE; sql_str VARCHAR2(256); nIgnore PLS_INTEGER; n number; ligne types.tab; -- table PL/SQL pour stocker le contenu d'une ligne begin connection_id :=...
  8. yassinemannai

    EXEC_SQL.DEFINE_COLUMN and PL/SQL TABLE

    declare connection_id EXEC_SQL.CONNTYPE; cursor_number EXEC_SQL.CURSTYPE; sql_str VARCHAR2(256); nIgnore PLS_INTEGER; n number; ligne types.tab; -- table PL/SQL pour stocker le contenu d'une ligne begin connection_id := EXEC_SQL.OPEN_CONNECTION('system/manager@odbc:testgct')...
  9. yassinemannai

    insert into test(1,5,6) values (12,'yassine','mannai');

    Hi, Can i insert a tuple in a table like this ligne of code: insert into test(1,5,6) values (12,'yassine','mannai'); in the place of this : insert into test(id,prenom,nom) values (12,'yassine','mannai'); thanks
  10. yassinemannai

    EXEC_SQL

    hi, I want to extract data from a n MS ACCESS table (test ) I write this code but the system generate error ORA-01403 /////////////////////// declare type tab is TABLE of varchar2(256) index by binary_integer; t tab; i number; j number; connection_id EXEC_SQL.CONNTYPE; cursor_number...
  11. yassinemannai

    can i import table from MS ACCESS via ODBC without using SQL* LOADER

    hi, when the user start his application,he must import table from MS ACCESS ( this table updated frequently by the DBA of MS ACCESS DB ) thanks
  12. yassinemannai

    Can I used trigger in MS ACCESS DB

    Hello, I have MS ACCESS DB ( 1 table : employe ). I attach a table ( emp ) from Oracle DataBase, I want to insert data to "emp" from "employe" can I write a trigger ( the same of Oracle trigger ) ( when user insert data to "employe", automatically...

Part and Inventory Search

Back
Top