Recent content by cosmini

hi there; I'm trying to debug a procedure that takes a date as parameter which needs to be the current sysdate (up to the second or millisecond). Is there a way to specify 'sysdate' as the value of the in parameter? PL/SQL Dev. seems to be complaining about that. thx, Cosmin

thx much Marco for the tip. I installed Ora Monitor 2.0 and surely enough I found the culprit in a sequence which had lost a grant.... :-)

hi Marco, we're having an issue w/ the TOraclewwDataSet in that we're getting an Ora 01031: insufficient prifilege. The insert works fine with the plain TOracleDataSet. Here's the snipped of code: the qCluster, a TOraclewwDataSet component's sql is defined as: SELECT CL.ROWID, CL.* FROM...

fixed it; type t_Sections is table of pls_integer index by binary_integer; I think DOA does not like "pls_integer", as I changed it to "integer" and all went well.

I had tried otFloat and got same exact error. I have just tried it, again, just to confirm and same thing. (using DOA 3.4.6.4 on Ora 8.1.6) [This message has been edited by cosmini (edited 20 October 2003).]

thanks much Marco, upgrading to 3.4.6.3 did the trick however now I'm getting a different type of error: "PLS-00418 array bind type must match pl/sql table row type." (on 8.1.6.1) In my example, which works if called within Toad, I have: type t_Sections is table of pls_integer index by...

hi Marco, how can I pass a table list to a TOracleDataSet? It appears that that's only available w/ a TOracleQuery component. I'm using DOA 3.4.3 thx, Cosmin [This message has been edited by cosmini (edited 15 October 2003).]

hello Marco, is there any way to retrive records from a database faster (other than setting the ReadBuffer to a higher value), like using bulk selects etc (through TOracleQuery) ? I need to retrieve a large number of records (for an optimized query whose' cost is '4') and the best I can do is...

thx Marco, that was exactly what was going on. [This message has been edited by cosmini (edited 17 March 2003).]

hi Marco, I'm using a two TOracleQuery to retrive a ref cursor data but I'm getting an error right at the execute of the first query. I've confirmed in Toad that the cursor has data and it's working fine. I'm basically using your example in the documentation but here's my code anyway: with...

hello there Marco, per your advice, I've set ReadBuffer to 1000, QueryAllRecords (also CountAllRecords) to False and here's what I'm getting: TStoredProc: Open: 40 ms Traverse: 7981 ms TOracleDataSet: Open: 70ms Traverse 3746 Looks like the Traverse time is better then 50% which is great...

...getting the TOracleQuery to work, I got: TOracleQuery: Open: 10 milliseconds Traverse: 4897 milliseconds which is pretty much, the same speed as the TStoredProc. For ease of use, I'd still want to use a TOracleDataSet if possible... thanks for any feedback on these issues. Cosmin

hello all, I have created a small benchmark app for my company to determine if DOA components are faster then BDE counterparts. We make extensive use of packages and cursor based packages. Here are the times benchmarks to open/traverse a 50,000 recordset through a TStoredProc vs a...