dbTalk Databases Forums  

Stored Procedures and BLOB (PDF files)

comp.databases.sybase comp.databases.sybase


Discuss Stored Procedures and BLOB (PDF files) in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Frank
 
Posts: n/a

Default Stored Procedures and BLOB (PDF files) - 11-12-2003 , 09:54 AM






Need some insight and help from the gurus. To set the knowledge
foundation - I know nothing about stored procedures, blobs, and
sybase. I have a Lotus Notes application that has captured information
and PDF attachments. I want to populate a Sybase database (ver 11.5)
with what is in Lotus Notes. I have been told that "Stored Procedures"
could transfer the data, but not the PDF file.

Is this true? If so, is there a workaround for this?

Thanks for all your help.
Franklin

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: Stored Procedures and BLOB (PDF files) - 11-12-2003 , 10:25 AM






On Wed, 12 Nov 2003 07:54:14 -0800, Frank wrote:

Quote:
Need some insight and help from the gurus. To set the knowledge foundation
- I know nothing about stored procedures, blobs, and sybase. I have a
Lotus Notes application that has captured information and PDF attachments.
I want to populate a Sybase database (ver 11.5) with what is in Lotus
Notes. I have been told that "Stored Procedures" could transfer the data,
but not the PDF file.
That is correct - you can't pass TEXT or IMAGE parameters to stored
procedures. There are a few other methods, but they depend on the
underlying API, and I have no idea what API Lotus Notes uses.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html



Reply With Quote
Reply




Thread Tools
Display Modes

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.