actionprocedures return varchar value problem

Posts   
 
    
PAZIMLI
User
Posts: 82
Joined: 01-May-2008
# Posted on: 26-Apr-2016 12:17:20   

**Hi

I write a Packege function related with PaswardValidation . It returns vharchar value

FUNCTION SifreUygunluk(pkullanici IN VARCHAR2, psifre IN VARCHAR2, pmsg VARCHAR2) RETURN varchar2

İf a password is valid, function returns "0" .**

I use this function in visual studio 2012 as shown below: But function returns " " instead of "0". And also if return value is "RAKAMIICERMELI", the message from .net returned value is "RAKAMII". Where is the rest of the returned value message ??

I mean when I try to use Oracle function from .net, function returns some of the returned string value, not returns all of the them.


                            string rtn = "";
                            string msg = "ssss";
                            int drtn = 0;
                            try
                            {


                                drtn = ActionProcedures.PkgMenuSifreuygunluk(_kullanici, tbYeni.Text, msg, ref rtn );

                                if (rtn != "0")
                                {
                                    MessageBox.Show(rtn);
                                    return;

                                }
                            }
                            catch (SystemException sysEx)

{ MessageBox.Show(sysEx.ToString()); }

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 26-Apr-2016 19:15:32   

Please provide more info on the LLBLGen Pro runtime build no., Oracle db version, provider used.

please check http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7719

Maktepe
User
Posts: 2
Joined: 24-Feb-2017
# Posted on: 06-Jul-2017 15:42:55   

Hi, we fixed this error smile Error when installing Oracle Client 12.1 version. We setup Oracle Client 11.2 version. It is ok.

Dear support team, please check LLBLGen v4.2 and Oracle Client 12.1 compatibility!

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39590
Joined: 17-Aug-2003
# Posted on: 06-Jul-2017 16:04:37   

Maktepe wrote:

Hi, we fixed this error smile Error when installing Oracle Client 12.1 version. We setup Oracle Client 11.2 version. It is ok.

Dear support team, please check LLBLGen v4.2 and Oracle Client 12.1 compatibility!

12.1 is compatible, we haven't had any problems with it, but if there's an issue in ODP.NET 12.x then you might run into it. That it returns " " instead of 0 is something we can't do much about, as whatever is returned by the proc is passed back, so there's no conversion of data... (so the difference is inside ODP.NET)

Frans Bouma | Lead developer LLBLGen Pro