create table via stored procedure (passing the table name to it)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
now i call it passing my desired table name
It works fine apart from the fact it ignores my desired table name of 'accounts' and instead creates a table called 'tname'
Is there something basic i'm doing wrong here?
any help would be greatly appreciated
Cheers
---------- Post updated at 06:13 AM ---------- Previous update was at 04:52 AM ----------
oops, i think ive posted this question in the wrong area, is there any chance a mod could move it to the correct area?
hi all
please tell me how to pass parameters 4m shell script to a DataBase stored procedure.
To be specific i have sybase DB.
i mean i want the syntax of the command..
how to connect to DB, pass user id and password, pass the required parameter to SP..
..
need ur help frnds..
hema (0 Replies)
Hi one help,
I need one procedure to load data from flat file to table. Table name as input parameter for the procedure. can anyone help me
Thanks,
Raj, (1 Reply)
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
Hi
I am new to Unix shell scripting. But i need help to slove the below issue.
Issue description:
I want to read table, view names and package names in a file
my plan to find the table name is : search "From" key word find the table or view
To find the packge name : Search "Package... (5 Replies)
Hi,
I want to create MySQL stored procedure and call the stored procedure using perl.
I tried like this:
use DBI;
my $dbh = DBI->connect ("DBI:mysql:test",
"root", "ibab",
{ RaiseError => 1, PrintError => 0});
$create_procedure =... (5 Replies)
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
I am new to this shell scripting....
I have a file which contains list of users. This files get updated when new user comes into the system.
I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT CENTOS
font::ttf::loca
Font::TTF::Loca(3) User Contributed Perl Documentation Font::TTF::Loca(3)NAME
Font::TTF::Loca - the Locations table, which is intimately tied to the glyf table
DESCRIPTION
The location table holds the directory of locations of each glyph within the glyf table. Due to this relationship and the unimportance of
the actual locations when it comes to holding glyphs in memory, reading the location table results in the creation of glyph objects for
each glyph and stores them here. So if you are looking for glyphs, do not look in the "glyf" table, look here instead.
Things get complicated if you try to change the glyph list within the one table. The recommendation is to create another clean location
object to replace this table in the font, ensuring that the old table is read first and to transfer or copy glyphs across from the read
table to the new table.
INSTANCE VARIABLES
The instance variables do not start with a space
glyphs
An array of glyph objects for each glyph.
glyphtype
A string containing the class name to create for each new glyph. If empty, defaults to Font::TTF::Glyph.
METHODS
$t->new
Creates a new location table making sure it has a glyphs array
$t->read
Reads the location table creating glyph objects (Font::TTF::Glyph) for each glyph allowing their later reading.
$t->out($fh)
Writes the location table out to $fh. Notice that not having read the location table implies that the glyf table has not been read either,
so the numbers in the location table are still valid. Let's hope that "maxp/numGlyphs" and "head/indexToLocFmt" haven't changed otherwise
we are in big trouble.
The function uses the OUTLOC location in the glyph calculated when the glyf table was attempted to be output.
$t->out_xml($context, $depth)
No need to output a loca table, this is dynamically generated
$t->glyphs_do(&func)
Calls func for each glyph in this location table in numerical order:
&func($glyph, $glyph_num)
BUGS
None known
AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing.
perl v5.16.3 2012-02-23 Font::TTF::Loca(3)