SQL> truncate table t1;Table truncatedSQL>
SQL> create or replace procedure test is
2 begin
3 INSERT INTO t1 VALUES(askpriceid.nextval,100);
4 end test;
5 /Procedure createdSQL> exec test;PL/SQL procedure successfully completedSQL> commit;Commit completeSQL> select * from t1; C1 C2
---------- ----------
162 100SQL>
SQL> create or replace procedure test is
2 begin
3 INSERT INTO t1 VALUES(askpriceid.nextval,100);
4 end test;
5 /Procedure createdSQL> exec test;PL/SQL procedure successfully completedSQL> commit;Commit completeSQL> select * from t1; C1 C2
---------- ----------
162 100SQL>
aaa number;select dianxinID_seq.nextval into aaa from dual;objcommand.Parameters.Add(New OracleParameter("dianxin_id", OracleType.Number)).Value =aaa