Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Stored procedure with blob parameter failed return a null output value



Permlink Replies: 4 - Last Post: May 19, 2016 2:03 PM Last Post By: Davide Apicella
Davide Apicella

Posts: 5
Registered: 2/13/15
Stored procedure with blob parameter failed return a null output value
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 12, 2016 10:23 AM
We have a problem with sql native client 2005 and a stored procedure.

Step:
-Create a stored procedure that insert values into a table with a blob field an return the scope_identity to a output parameter.
-create a firedac connection
-create the firedac stored procedure
-assign the input parameter
-execute the stored procedure
-check the output parameter

The outparameter is null instead of the identity column value

This happen only when on the machine is installed sql native client 2005

Is a firedac bug?
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Stored procedure with blob parameter failed return a null output value
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 12, 2016 11:12 PM   in response to: Davide Apicella in response to: Davide Apicella
Please provide FireDAC environment report:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/DBMS_Environment_Reports_%28FireDAC%29

--
With best regards,
Dmitry
Davide Apicella

Posts: 5
Registered: 2/13/15
Re: Stored procedure with blob parameter failed return a null output value
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 13, 2016 1:11 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Dmitry Arefiev wrote:
Please provide FireDAC environment report:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/DBMS_Environment_Reports_%28FireDAC%29

--
With best regards,
Dmitry

Hi Dmitry,
My enviroment report is:
================================
Connection definition parameters
================================
SERVER=localhost
ApplicationName=Enterprise/Architect/Ultimate
Workstation=MI-DEV001
MARS=yes
Database=TESTDB01
OSAuthent=Yes
DriverID=MSSQL
================================
FireDAC info
================================
Tool = RAD Studio 10 Seattle
FireDAC = 13.0.1 (Build 82709)
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver MSSQL ...
Loading odbc32.dll driver manager
Creating ODBC environment handle
Searching for ODBC driver ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 11.0] ...
Checking for ODBC driver [ODBC DRIVER 11 FOR SQL SERVER] ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 10.0] ...
Checking for ODBC driver [SQL NATIVE CLIENT] ...
Found [SQL Native Client]
Driver Manager version = 03.81.10586.0000
================================
Session info
================================
Checking session ...
Warning: The client [9.0.0.0.0] and server [11.0.0.0.0] major versions difference > 1.
Current catalog =
Current schema = dbo
Driver name = SQLNCLI.DLL
Driver version = 09.00.2047
Driver conformance = 3
DBMS name = Microsoft SQL Server
DBMS version = 11.00.5343

My SQL SERVER is 2012 but i have the problem also on 2008 and 2014 editions

Thanks

Davide Apicella

Posts: 5
Registered: 2/13/15
Re: Stored procedure with blob parameter failed return a null output value
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 13, 2016 1:17 AM   in response to: Davide Apicella in response to: Davide Apicella
here you can find a sample Project with the script to create Database, tables and stored procedures and the output of the firedac Monitor

https://forums.embarcadero.com/thread.jspa?threadID=211521&tstart=0

I hope this can help

Davide Apicella wrote:
Dmitry Arefiev wrote:
Please provide FireDAC environment report:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/DBMS_Environment_Reports_%28FireDAC%29

--
With best regards,
Dmitry

Hi Dmitry,
My enviroment report is:
================================
Connection definition parameters
================================
SERVER=localhost
ApplicationName=Enterprise/Architect/Ultimate
Workstation=MI-DEV001
MARS=yes
Database=TESTDB01
OSAuthent=Yes
DriverID=MSSQL
================================
FireDAC info
================================
Tool = RAD Studio 10 Seattle
FireDAC = 13.0.1 (Build 82709)
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver MSSQL ...
Loading odbc32.dll driver manager
Creating ODBC environment handle
Searching for ODBC driver ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 11.0] ...
Checking for ODBC driver [ODBC DRIVER 11 FOR SQL SERVER] ...
Checking for ODBC driver [SQL SERVER NATIVE CLIENT 10.0] ...
Checking for ODBC driver [SQL NATIVE CLIENT] ...
Found [SQL Native Client]
Driver Manager version = 03.81.10586.0000
================================
Session info
================================
Checking session ...
Warning: The client [9.0.0.0.0] and server [11.0.0.0.0] major versions difference > 1.
Current catalog =
Current schema = dbo
Driver name = SQLNCLI.DLL
Driver version = 09.00.2047
Driver conformance = 3
DBMS name = Microsoft SQL Server
DBMS version = 11.00.5343

My SQL SERVER is 2012 but i have the problem also on 2008 and 2014 editions

Thanks

Davide Apicella

Posts: 5
Registered: 2/13/15
Re: Stored procedure with blob parameter failed return a null output value
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 19, 2016 2:03 PM   in response to: Davide Apicella in response to: Davide Apicella
Hi Dmitry,
Do you have any update?

Thanks

Davide
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02