Recent content by lionna

Surprisingly, this doesn't work: '... With cmd Set .ActiveConnection = cn .CommandText = "S#mdb$stg_da_extr_util.get_all_classes_of_classif" .CommandType = adCmdStoredProc .Parameters.Refresh 'ORA-06550 Wrong number or types of arguments in call to...

Hallulujah!!! Finally I made it! My guess about wrong connector was correct! It is not possible to call stored oracle functions using ODBC. Instead, 'Microsoft OLE DB for Oracle' Driver should be used here. Then we need to create new connector, in order to make it work. Here's the code (VBA...

No mis-spellings found. Still can't get it work. Here's what I have also tried (I know you mentioned that there's no need to create parameters, didn't work for me though...). Public Sub obj_class() Dim cnn As ADODB.Connection Dim cmd As ADODB.Command Dim strConn As String Set...

hi Michael wasn't able to get over my error ;( I am really stuck und you're the only hope I have... I couldn't attach the screenshot, 'cause I have only 4 posts in this forum. Anyway, when I explore my adoCMD Object in detail, the parameters of the function are not there... Under Parameters I...

thanks again for the tipps. Unfortunately, I couldn't manage to make my code work... I do run the code in debug mode, now I get following error: Public Sub obj_classif() Dim cn As New ADODB.Connection Dim strSQL As String Dim db_name, Username, Password As String Dim adoCMD...

Yes, this library is also available. omg, sorry, I am not a DB Expert. What I meant is, when I call this function in e.g. SQL Developer, the return appears in Script Output, and not in Results, where you normally expect the results from SELECT query to appear... I have changed the code to this...

thanks for such a quick answer. Yes, the library Microsoft ADO Ext. 2.8 for DDL and Security is enabled. My problem is, that I can't save the return value of one oracle stored procedure. The return value of the function is semi-colon separated string, and not the recordset. Here is the code...

Dear Michael question: is this code valid only for MS Access? When I run it in Excel, I get an error, that the ODBC Driver doesn't support the properties. The error appears here: Set adoRS = .Execute() Do you happen to know, what is the reason? Thanks in advance, Lionna