Re: Emergency help needed with oracle insert!!!

[Les Hancock <les_hanc@YAHOO.COM>]

Your code worked fine for me:

select business_unit,VOUCHER_Id
from ps_pymnt_wthd_book
where business_unit = 'BIPER'

BUSIN VOUCHER_
----- --------
BIPER 00077815

DMO75>


You say the SQR freezes.  What do you mean?

p.s.

I hope this response doesn't cause any controversy.


Les


---"Buchanan, Timothy" <buchanan@BIPERF.COM> wrote:
>
> Howdy,
>
> Much thanks is given in advance...
>
> I am trying to insert data into an oracle table. here is my
bare-bones sqr:
>
> #include 'setenv.sqc'
> begin-program
> display 'Step#1'
> begin-sql
> on-error=insert-error
> insert into PS_PYMNT_WTHD_BOOK
> (BUSINESS_UNIT, VOUCHER_ID, PYMNT_CNT, VOUCHER_LINE_NUM , WTHD_ENTITY,
> WTHD_TYPE, WTHD_CLASS, LEDGER_GROUP , LEDGER , BASE_CURRENCY ,
> CUR_RT_TYPE_PYMNT , PYMNT_RATE_MULT, PYMNT_RATE_DIV ,
WTHD_BASIS_AMT_BSE,
> WTHD_AMT_BSE, PRIMARY_LEDGER , PROCESS_INSTANCE)
> values
> ('BIPER', '00077815', 1, 1, 'IRS', '1099', '07', 'ACTUALS', 'ACTUALS',
> 'USD', 'CRRNT', 1.0, 1.0, 123.45, 123.45, 'Y', 5555)
> end-sql
> display 'Step #2'
> end-program
> begin-procedure insert-error
> display 'error'
> STOP
> end-procedure
>
>
> When I run it, it does not get past "Step #1", and freezes up. I can
run
> other SQR's that insert data into other tables, no problem. Their
syntax is
> the exact same as mine. I can cut and paste the SQL above into SQL+
and run
> it with no problem, it inserts the data. HELP! I am losing my mind!
Thanks
> again
>
> Timm Buchanan
>

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com