&dbcmd($proc, "SELECT  crdate into #tmp_table FROM sysobjects \n");

&dbsqlexec($proc);

&dbcmd($proc, "SELECT * FROM #tmp_table \n");

&dbsqlexec($proc);