Re: passing table name as parameter - CORRECTION

By the way = To Anurag Varma - yes, that was the right solution. Thanks!!

Sorry for the multiple posts, it's way too late for me..................

pat

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:undjp777u30rc4_at_corp.supernews.com...
> I don't think there is a stored procedure she is calling.
> Though I barely know VB, but it seems like she is trying to
> "prepare" a statement while trying to provide table_name as
> a bind variable.
> That of course should not work.
>
> Maybe this will
> > > > .CommandText = "truncate table " & table_name
> .. and throw that .Append ... bind param .. thingie out.
>
> Just a guess ....
>
> Anurag
>
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
 news:v3zd9.361256$UU1.59355_at_sccrnsc03...
> > Where is the pl/sql stored procedure you are calling? That is probably
> > where the error is.
> > I hope this is an occaisional thing and not some SQLServer like temp
 table
> > thing. If it is I would recommend not doing this; instead do it without
 a
> > temp table. (Oracle can have a type of temp table see Global temporary
> > tables, if you really really need it.) If it is an occaisional thing
 (this
> > kills scalability) then in your pl/sql function use execute immediate.
> > Jim
> >
> > "Patricia Paulson" <miapjp_at_chartermi.net> wrote in message
> > news:unced142ivqa4a_at_corp.supernews.com...
> > > whoops, in sub it's
> > > Sub truncate_table(table_name as string)
> > >
> > > I forgot to put in the parameter after taking it out to check
 hard-coded
> > > results.
> > >
> > > Pat
> > >
> > > "Patricia Paulson" <miapjp_at_chartermi.net> wrote in message
> > > news:unce21sh25r1cd_at_corp.supernews.com...
> > > > Hi,
> > > >
> > > > I'm having problems using the truncate command when I'm passing in
 the
 table
> > > > name. Hard-coding works fine, so I'm thinking it's something to do
 with
 DDL
> > > > and the double quotes for a string var????? I've tried all sorts of
 things,
> > > > and searched the Web for hours. Any help would be greatly
 appreciated!!!
> > > >
> > > > Code:
> > > >
> > > > calling the sub:
> > > > truncate_table ("im_header") ' I tried inlcuding the schema name
 also,
 no
> > > > go.
> > > >
> > > > the sub:
> > > > Sub truncate_table()
> > > >
> > > > On Error GoTo err_hand
> > > >
> > > > Dim truncate_table As ADODB.Command
> > > > Dim table_name_parm As ADODB.Parameter
> > > >
> > > > Set truncate_table = New ADODB.Command
> > > >
> > > > With truncate_table
> > > > .ActiveConnection = rtkprd
> > > > .CommandType = adCmdText
> > > > .CommandText = "truncate table ?"
> > > > Set table_name_parm = .CreateParameter("table_name",
 adVarChar,
> > > > adParamInput, 50, table_name)
> > > > .Parameters.Append table_name_parm
> > > > .Execute
> > > > End With
> > > >
> > > > Exit Sub
> > > >
> > > > err_hand:
> > > >
> > > > Err.Raise Err.Number, , Err.Description & vbCrLf & "Error
 truncating
> > > > tables."
> > > >
> > > > Exit Sub
> > > >
> > > >
> > > > Thanks in advance!
> > > >
> > > > Pat
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu Sep 05 2002 - 00:46:50 CDT