We have a PB app that connects to an oracle database "AAA" and do most of its functions.
Now there is send_email function needed in the application. This function will need to lookup a BLOB file in table X in database BBB. There is a db link between database AAA and BBB. However, oracle does not allow us to create a view or synonym in AAA for the table in BBB because of the BLOB column.
PB coder asked me to create local views in BBB to access all tables in AAA because they do not show up on his IDE.
Does anyone know what is the best way to do this in PB?
Cant PB create a second connection directly into BBB with userid/password and then do the SELECT from that table. do you have to close first connection or can stay open.
2. Does PB have an API to send emails with attachments. I want to send that text file as an email attachment.
3. In sybase IDE, does it show the data sources based on oracle tns file or you define the different sources to access the various tables you want to access.
thanks,
Start Free Trial
