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 derfloh 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. andyskinner

    Crystal Reports 8.5 will not install Native Oracle Drivers

    Crystal is dependant on the Oracle client interface files, namely the OCI*.DLLs on the machine. Oracle, for backwards compatibility installs historic versions of these, for older versions of Oracle, so the fact that you have an Oracle7 Native driver should be ok. The database connectivity...
  2. andyskinner

    ADO Command and Oracle Ref Cursor

    I thought I might add that the parameter types I`m working with are dates, and I`m thinking this could be a problem. Not sure what to do about it though. Andy
  3. andyskinner

    ADO Command and Oracle Ref Cursor

    Hya, I have an ADO command which calls an Oracle stored procedure that exposes a Ref Cursor. This calls ok, and I can get column names from the resultset of the procedure, however, it always says the recordcount is Zero and the recordset is empty, even though when executed in Oracle the...
  4. andyskinner

    Problem calling PLSQL Function

    Problem over. It appears that the developer of this function had put a catch all exception in that returned zero. On removing this, the real error was showing. The function was doing an UPDATE somewhere in the code and so Oracle wouldn`t allow it from a SELECT Statement! Andy.
  5. andyskinner

    Changing Outer Join Syntax

    I think it creates the old Star Equals syntax for backward compatibility..... What have you set in the link options between the 2 tables Ken? Is it just Left Outer Join? Using ODBC shouldn`t force you to manually modify the SQL either? If your solution has to scale, using Native drivers...
  6. andyskinner

    Problem calling PLSQL Function

    Sorry. cpi_act_start_date is a date type. cpi_act_end_date is a date type. cpi_id is a number. Thx for the help. Andy.
  7. andyskinner

    Problem calling PLSQL Function

    BTW, You can`t call a SQL Function in a Select statment without using positional notation, not in Oracle 8i anyway. Named and mixed notations are not allowed. Ta, Andy.
  8. andyskinner

    Problem calling PLSQL Function

    Heres the function header (slightly anonymised) it`s just an interface function for a function that lives in a package; CREATE OR REPLACE FUNCTION PARIS.FNC_CALCULATE_COST(ciCpiID IN cpl_inter.cpi_id%TYPE, cdStart IN...
  9. andyskinner

    Problem calling PLSQL Function

    Hya, Have a huge PLSQL function that does a bunch of calculations. The function works fine when tested in a begin statement like so; begin -- Call the function :result := something.fnc_calculate_cost(cicpiid => :cicpiid, cdstart => :cdstart...

Part and Inventory Search

Back
Top