Recent content by misuk11

  1. M

    WINDOWS SOCKET ERROR 10048

    Im getting the following error WINDOWS SOCKET ERROR 10048 anyone know what causes this ? tia
  2. M

    Testing a procedure

    I have a procedure within a package that takes several input paramaters and returns a recordset. If I activate the TOraclewwQuery component from Delphi I get an error 'Invalid SQL statement' Its quite a complicated procedure, Ive tested the individual bits of SQL within it and they work OK...
  3. M

    Ref Cursors

    Im trying to retrieve a recordset from a stored procedure and have creted the procedure below. What is the correct way to call this from a TOraclewwDataset component in Delphi ? this is the SQL BEGIN Artist.GETARTISTS(); END; I get an error 'wrong number or types of argument' What should the...
  4. M

    cursors

    im using a cursor to retrieve a dataset into a TOraclewwDataset component. The procedure compiles ok and seems to run but no feilds are being returned. I have the TOraclewwDataset component linked to a datagrid but the grid shows no columns. Heres the procedure PROCEDURE TEST(ARID OUT...
  5. M

    lockingmode & cached updates

    if the locking mode on a dataset is set to ImCheckImmediate and cached update is set to true, aren't they both mutually exclusive ? If cached updates are on will ImCheckImmediate have no effect ?
  6. M

    Views

    can anyone tell me how I grant select access to specific roles for a view ? With a table i just right click, edit and add the role, a view doesnt have an equivalent mechanism.
  7. M

    integer columns

    using Oracle 10g im accessing a table with an 'id' column of datatype NUMBER, data length 22, data precision 10 and data scale 0. The delphi app had previously been connected to a sybase database and cloumn 'id' was defined as an integer, so the column type for 'id' had been set to...
  8. M

    scan sql

    i have TOracleQuery component pointing to an oracle package. There are multiple variables (both in and out) as below p_p_id IN INT, p_source IN INT, p_title OUT prg.epg_title%TYPE, p_desc OUT...
Back
Top