You should include more code, such as the declaration of DBSecTime. And what is this ?
That's not C code.
Hi otheus, sorry about that, I have included more codes.
exec sql select * from tableA where time < : DBSecTime, this is actually a embedded sql statement in my C code. I just find it strange that the 2 sprintf statement was able to run smoothly but not the DBSecTime that was in the sql statement. I have even try to replace DBSecTime in the sql statement with a value like "200812000000" and it managed to got thru too.
This may belong in the C Programming forum, but here goes anyway...
What would cause a bus error? I searched google for a cause, but came up with some conflicting reports...
Could it be caused by disk space?
A lot of the pages I found mentioned linking with the incorrect versions of the... (4 Replies)
aix 5.3 ML1
system was functioing well, when suddenly telnet session hung and then I got the following message "Bus error(coredump)"
would appreciate if anyone would assist as to what to do next. (3 Replies)
Hi,
I am using HP-UX.
While i try to run the Sqlplus command using the shel script in encounter the following error:
<shell script name>: some number Bus Error(coredump)
What may be the reason behind this.
I read few previous threads in this forum where i found some similar case. There it was... (2 Replies)
Hi!
I've got a program which runs fine under Linux, but I have compiled it to run under SunOS 5.8 in a Sparc computer, and now it sometimes fails with "bus error".
Ussing gdb I surfed to the error line, which is
*pointer = some_vector;
where some_vector is a 16 byte struct (4 integers)... (1 Reply)
Hi All,
I am getting coredump error, when I try to execute Oracle SQL*Loader from Shell script in Unix environment. But SQL*Loader from local machine runs fine with same database.
SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 05:23:47 2007
Copyright (c) 1982, 2002, Oracle... (3 Replies)
Hi all,
I am getting bus error problem in SunOS. Can you please help me out in this regard.
Actually, my entire code till the last line has been executed. But after tht i am getting a bus error. Please help me.
Thanks in advance.
Charu. (4 Replies)
Hi all,
I am trying to create few directories using script and its giving me segmentation error.
#!/bin/ksh
createDirectories()
createDirectories()
{
cat dirs | \
while read line
do
mkdir... (16 Replies)
I am getting bus error when i include "#!/bin/ksh". If i remove interpreter then script is working. Can anyone explain this and how can i avoid this error?
Operating System is HP-UX B.11.23 U 9000/800 1091834454 (2 Replies)
Hi everyone,
I have a GUI project and when I run it and left in idle state for a long time(there is nothing done, just opened GUI, no more actions),I get bus error after trying to do anything with it.
I've tried to build it in debug mode and use gdb, but I don't get any error in debug mode.It... (3 Replies)
Hi all,
I am writing a phonebook program to store names and number using a list. Here is the code for the function which allows the user to enter the name and number (where the error occurs).
//THIS FUNCTION ADDS A NEW ENTRY TO THE phonebook_list
void insert(void){
//variables
int... (5 Replies)
Discussion started by: kdejan
5 Replies
LEARN ABOUT PHP
fbsql_read_blob
FBSQL_READ_BLOB(3) 1 FBSQL_READ_BLOB(3)fbsql_read_blob - Read a BLOB from the databaseSYNOPSIS
string fbsql_read_blob (string $blob_handle, [resource $link_identifier])
DESCRIPTION
Reads BLOB data from the database.
If a select statement contains BLOB and/or CLOB columns FrontBase will return the data directly when data is fetched. This default behav-
ior can be changed with fbsql_set_lob_mode(3) so the fetch functions will return handles to BLOB and CLOB data. If a handle is fetched a
user must call fbsql_read_blob(3) to get the actual BLOB data from the database.
PARAMETERS
o $blob_handle
- A BLOB handle, returned by fbsql_create_blob(3).
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns a string containing the specified BLOB data.
EXAMPLES
Example #1
fbsql_read_blob(3) example
<?php
$link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
$sql = "SELECT BLOB_COLUMN FROM BLOB_TABLE;";
$rs = fbsql_query($sql, $link);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain the blob data for the first row
fbsql_free_result($rs);
$rs = fbsql_query($sql, $link);
fbsql_set_lob_mode($rs, FBSQL_LOB_HANDLE);
$row_data = fbsql_fetch_row($rs);
// $row_data[0] will now contain a handle to the BLOB data in the first row
$blob_data = fbsql_read_blob($row_data[0]);
fbsql_free_result($rs);
?>
SEE ALSO fbsql_create_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).
PHP Documentation Group FBSQL_READ_BLOB(3)