I'm integrating filemaker with oracle but i can't store file in oracle. I have created tables with data type of BLOB and i have created directories but still now i can store files in oracle.How can i do this?
Are you sure your Oracle User ID has write access to the file? Test it out with SQLPlus and let us know if that works.
I tested the connection is succesfull. I'm getting all fields except the BLOB datatype field which stores files. tht's my question?
Are you trying to GET the ORACLE data into FileMaker (import) or VIEW the ORACLE data in FileMaker with External SQL Source (ESS)?
and/or are you trying to PUT the blob data into ORACLE through the FileMaker interface.
My front end is Filemaker and my back end is Oracle what I'm entering in filemaker the data's will get stored in Oracle.I can able to enter all the data's into the oracle usig filemaker but i cant insert file into oracle using filemaker.The container datatype which is present in filmaker is equal to BLOB datatype which is present in Oracle, I'm not geting that single BLOB datatype field while integrating with ODBC.
The last time I tested FM<>SQL integration, the BLOB and FileMaker container translaters did not seem to work together for actual file storage within container fields.
I would contact FMI about the specs on this and whether or not this can be done successfully at all before beating my head against the wall to make it work.
Stephen's right. Perhaps the link on this forum would help you get the answers you need: https://fmdev.filemaker.com/docs/DOC-1117
Also the xDBC guide is most helpful.
Apparently Beverly is correct. FileMaker does not support binary fields with any of the ESS tables. I bet you could do something like using a script to export the container field to a particular location and store that location in an Oracle text field and then have Oracle import that binary from that location. I wonder if 360 Works has any such experience since they do things like this with SuperContainer.
As others stated, ESS does not support binary data. Be sure to put a feature request in with Filemaker, as this is something many of us would like to see added to the features list.
You may be able to engineer your way around this using the Filemaker Web Portal and developing a web interface for saving and retrieving your binary data in Oracle. You can then integrate the Web solution in Filemaker via the Web Portal/Viewer. You may want to take a look at Real Basic for doing an interface, or Oracle APEX, RB is relatively inexpensive and Oracle APEX (Application Express) is free. It is not trivial work, but it can be done.
Ok if you got any idea intimate me. . .
I'll Try my best. If you got any idea intimate me.
Retrieving data ...