Search results for query: *

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

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

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

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.

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

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.

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.

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

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