Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 27th, 2006, 09:26 AM
wotaen wotaen is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 10 wotaen User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 39 m 41 sec
Reputation Power: 0
Passing BLOB parameter to stored procedure problem

Hi all, i got strange problem...
This is my procedure
CREATE PROCEDURE NEW_AGENCY (
NAME VARCHAR(300),
DESCRIPTION BLOB SUB_TYPE 1 SEGMENT SIZE 80,
ADDRESS_NAME VARCHAR(300),
STREET VARCHAR(300),
STREET_NO VARCHAR(300),
COUNTRY SMALLINT,
LOCATION SMALLINT,
EMAIL VARCHAR(100) CHARACTER SET ASCII,
PHONE VARCHAR(100) CHARACTER SET ASCII,
FAX VARCHAR(100) CHARACTER SET ASCII,
PERSON VARCHAR(300),
PREFFERED SMALLINT,
CREATOR INTEGER,
ZIP VARCHAR(100) CHARACTER SET ASCII,
LOGIN VARCHAR(50) CHARACTER SET ASCII,
USERROLE SMALLINT,
PASS VARCHAR(32) CHARACTER SET ASCII,
SALT VARCHAR(32) CHARACTER SET ASCII)
AS
DECLARE VARIABLE USERID INTEGER;
begin
insert into users (login,userrole,"PASSWORD",salt) values (:login,:userrole,***,:salt);
select gen_id(gen_users_id,0) from rdb$database into :userid;
insert into agencies (name,description,address_name,street,street_no,country,location,email,phone,fax,person,preffered,cr eator,dbuser,zip)
values (:name,:description,:address_name,:street,:street_no,:country,:location,:email,hone,:fax,erson,: preffered,:creator, :userid,:zip);
end

When executing the procedure: execute procedure new_agency(...) internal error is returned (leaving no clue, what happened). When i remove the description parameter it is ok.
The interesting thing is, that in different db, on the same server, i have another stored procedure which uses blob parameters and it works ok, so what am i missing??
Thanks a lot for help.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > Passing BLOB parameter to stored procedure problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway