Asp Forum - Calling an Oracle Store Procedure - microsoft.public.dotnet.framework.odbcnet

Carol K

11/29/2006 2:01:00 PM

When I call a stored procedure from my app, I recieve the following message

ORA-06550: line1, Column 7:

PLS-00801: internal error [22503]

The code is ...

OracleCommand^ UserPassCmd = gcnew
OracleCommand("UNIX_PACK.VERIFY_ID(log_name, inuserpasswd, inapplid,
outuserid, outuserpasswd, outrc, outmess)",NestConnection);

UserPassCmd->CommandType = CommandType::StoredProcedure;

OracleParameter^ parmlog_name =
UserPassCmd->Parameters->Add("log_name",OracleType::VarChar,USER_PASS);

parmlog_name->Direction = ParameterDirection::Input;

parmlog_name->Value = log_name;

OracleParameter^ parminuserpasswd =
UserPassCmd->Parameters->Add("inuserpasswd",OracleType::VarChar,USER_PASS);

parminuserpasswd->Direction = ParameterDirection::Input;

parminuserpasswd->Value = "Passwd";

OracleParameter^ parminapplid =
UserPassCmd->Parameters->Add("inapplid",OracleType::VarChar,USER_PASS);

parminapplid->Direction = ParameterDirection::Input;

parminapplid->Value = "Generic Apps";

OracleParameter^ parmoutuserid =
UserPassCmd->Parameters->Add("outuserid",OracleType::VarChar,USER_PASS);

parmoutuserid->Direction = ParameterDirection::Output;

OracleParameter^ parmoutuserpasswd =
UserPassCmd->Parameters->Add("outuserpasswd",OracleType::VarChar,USER_PASS);

parmoutuserpasswd->Direction = ParameterDirection::Output;

OracleParameter^ parmoutrc =
UserPassCmd->Parameters->Add("outrc",OracleType::Int16);

parmoutrc->Direction = ParameterDirection::Output;

OracleParameter^ parmoutmess =
UserPassCmd->Parameters->Add("outmess",OracleType::VarChar,TEXT_LINE);

parmoutmess->Direction = ParameterDirection::Output;

UserPassCmd->ExecuteNonQuery();

This stored procedure executes without issues from an Oracle Forms app.

Thanks

Carol K

6 Answers

MHS

6/9/2010 3:05:00 AM

> Gary tried putting the disc in his NES, but all it did was blink when he
> pushed the button! :)
>

Very, very funny.

Abby Normal

6/10/2010 5:02:00 AM

On Jun 8, 7:59 pm, taylor34 <at93...@yahoo.com> wrote:
> Resident Evil? Really? That seems really....stretching it. It's
> popular but not that popular. Halo, Final Fantasy, Call of Duty, Rock
> Band, etc all dwarf it in comparison. In fact it probably isn't even
> the top 10 as far as video game franchises go anymore. I won't really
> believe it until I see it, that just seems like so much of a stretch.
> Ironically, Halo Reach is also timed right then as well.

I think Fallout 3 would make a great table. I'd rather see an original
game, but they could even retheme WOF with Fallout. Change the
contestants to Vault Boy bobbleheads, replace the wheel with a vault
door and so on. And they do have 2 sequels on the way.

That might even tempt me enough to buy NIB!

Steven

6/10/2010 7:58:00 AM

> I think Fallout 3 would make a great table. I'd rather see an original
> game, but they could even retheme WOF with Fallout. Change the
> contestants to Vault Boy bobbleheads, replace the wheel with a vault
> door and so on. And they do have 2 sequels on the way.
>
> That might even tempt me enough to buy NIB!

I think Harry Potter would make a great theme for a pinball, even
though it might be a bit late to get the license now instead of a few
years ago.
Retheming WOF is a good option I think (though maybe not with the HP
theme), for most negative comments about that game are about theme and
software, not the layout.

Rare Hero

6/13/2010 12:55:00 AM

On Jun 12, 2:21 pm, Barney <Le...@Leica.com> wrote:
> I think it's time they had another scary title.
>
> Barney

Barney WOULD be a scary title!

;)

Greg

Brian Munn

6/13/2010 1:04:00 AM

Gears of War?

Brian
Detroit Pinball

twilightzonepinball

6/17/2010 9:40:00 PM

On Jun 10, 1:02 am, Abby Normal <missabbynor...@gmail.com> wrote:
> On Jun 8, 7:59 pm, taylor34 <at93...@yahoo.com> wrote:
>
> > Resident Evil? Really? That seems really....stretching it. It's
> > popular but not that popular. Halo, Final Fantasy, Call of Duty, Rock
> > Band, etc all dwarf it in comparison. In fact it probably isn't even
> > the top 10 as far as video game franchises go anymore. I won't really
> > believe it until I see it, that just seems like so much of a stretch.
> > Ironically, Halo Reach is also timed right then as well.
>
> I think Fallout 3 would make a great table. I'd rather see an original
> game, but they could even retheme WOF with Fallout. Change the
> contestants to Vault Boy bobbleheads, replace the wheel with a vault
> door and so on. And they do have 2 sequels on the way.
>
> That might even tempt me enough to buy NIB!

WOF is a POS so yes buy one NB!

-Tom

http://home.myfairpoint.net/vze8f4tt/tomstwilightzonepinballmachineaccessories/...

microsoft.public.dotnet.framework.odbcnet

Calling an Oracle Store Procedure