Database reference - demo

demo -  procedure parameters

All procedure parameters

proceduretypeparameterdatatypelengthin/outcomment
ManageContactsPactionchar1in 
ManageContactsPcontact_IDinteger4in 
ManageContactsPcontact_new_IDinteger4in 
ManageContactsPcontact_surnameperson_name_t20in 
ManageContactsPcontact_given_nameperson_name_t20in 
ManageContactsPcontact_titleperson_title_t34in 
ManageContactsPcontact_streetstreet_t30in 
ManageContactsPcontact_citycity_t20in 
ManageContactsPcontact_statestate_t16in 
ManageContactsPcontact_countrycountry_t16in 
ManageContactsPcontact_postal_codepostal_code_t10in 
ManageContactsPcontact_phonephone_number_t13in 
ManageContactsPcontact_faxphone_number_t13in 
ShowContactsPcontact_IDinteger4in 
ShowCustomerProductsPcustomer_IDinteger4in/out 
ShowProductInfoPproduct_IDinteger4in/out 
ShowSalesOrderDetailPcustomer_IDinteger4in 
ShowSalesOrderDetailPproduct_IDinteger4in 
ShowSalesOrderItemsPorder_IDinteger4in 
ShowSalesOrdersPcustomer_IDinteger4in 
ml_add_columnP@versionvarchar128in 
ml_add_columnP@tablevarchar128in 
ml_add_columnP@columnvarchar128in 
ml_add_columnP@typevarchar128in 
ml_add_connection_scriptP@versionvarchar128in 
ml_add_connection_scriptP@eventvarchar128in 
ml_add_connection_scriptP@scripttext32767in 
ml_add_dnet_connection_scriptP@versionvarchar128in 
ml_add_dnet_connection_scriptP@eventvarchar128in 
ml_add_dnet_connection_scriptP@scripttext32767in 
ml_add_dnet_table_scriptP@versionvarchar128in 
ml_add_dnet_table_scriptP@tablevarchar128in 
ml_add_dnet_table_scriptP@eventvarchar128in 
ml_add_dnet_table_scriptP@scripttext32767in 
ml_add_java_connection_scriptP@versionvarchar128in 
ml_add_java_connection_scriptP@eventvarchar128in 
ml_add_java_connection_scriptP@scripttext32767in 
ml_add_java_table_scriptP@versionvarchar128in 
ml_add_java_table_scriptP@tablevarchar128in 
ml_add_java_table_scriptP@eventvarchar128in 
ml_add_java_table_scriptP@scripttext32767in 
ml_add_lang_conn_script_chkP@versionvarchar128in 
ml_add_lang_conn_script_chkP@eventvarchar128in 
ml_add_lang_conn_script_chkP@script_languagevarchar128in 
ml_add_lang_conn_script_chkP@scripttext32767in 
ml_add_lang_conn_script_chkP@checksumvarchar64in 
ml_add_lang_connection_scriptP@versionvarchar128in 
ml_add_lang_connection_scriptP@eventvarchar128in 
ml_add_lang_connection_scriptP@script_languagechar128in 
ml_add_lang_connection_scriptP@scripttext32767in 
ml_add_lang_table_scriptP@versionvarchar128in 
ml_add_lang_table_scriptP@tablevarchar128in 
ml_add_lang_table_scriptP@eventvarchar128in 
ml_add_lang_table_scriptP@script_languagevarchar128in 
ml_add_lang_table_scriptP@scripttext32767in 
ml_add_lang_table_script_chkP@versionvarchar128in 
ml_add_lang_table_script_chkP@tablevarchar128in 
ml_add_lang_table_script_chkP@eventvarchar128in 
ml_add_lang_table_script_chkP@script_languagevarchar128in 
ml_add_lang_table_script_chkP@scripttext32767in 
ml_add_lang_table_script_chkP@checksumvarchar64in 
ml_add_passthroughP@remote_idvarchar128in 
ml_add_passthroughP@script_namevarchar128in 
ml_add_passthroughP@run_orderinteger4in 
ml_add_passthrough_repairP@failed_script_namevarchar128in 
ml_add_passthrough_repairP@error_codeinteger4in 
ml_add_passthrough_repairP@new_script_namevarchar128in 
ml_add_passthrough_repairP@actionchar1in 
ml_add_passthrough_scriptP@script_namevarchar128in 
ml_add_passthrough_scriptP@flagsvarchar256in 
ml_add_passthrough_scriptP@affected_pubstext32767in 
ml_add_passthrough_scriptP@scripttext32767in 
ml_add_passthrough_scriptP@descriptionvarchar2000in 
ml_add_propertyP@comp_namevarchar128in 
ml_add_propertyP@prop_set_namevarchar128in 
ml_add_propertyP@prop_namevarchar128in 
ml_add_propertyP@prop_valuevarchar4000in 
ml_add_table_scriptP@versionvarchar128in 
ml_add_table_scriptP@tablevarchar128in 
ml_add_table_scriptP@eventvarchar128in 
ml_add_table_scriptP@scripttext32767in 
ml_add_userP@uservarchar128in 
ml_add_userP@passwordbinary32in 
ml_delete_deviceP@devicevarchar255in 
ml_delete_device_addressP@devicevarchar255in 
ml_delete_device_addressP@mediumvarchar255in 
ml_delete_listeningP@namevarchar128in 
ml_delete_passthroughP@remote_idvarchar128in 
ml_delete_passthroughP@script_namevarchar128in 
ml_delete_passthroughP@run_orderinteger4in 
ml_delete_passthrough_repairP@failed_script_namevarchar128in 
ml_delete_passthrough_repairP@error_codeinteger4in 
ml_delete_passthrough_scriptP@script_namevarchar128in 
ml_delete_sync_stateP@uservarchar128in 
ml_delete_sync_stateP@remote_idvarchar128in 
ml_delete_sync_state_beforeP@tstimestamp8in 
ml_delete_userP@uservarchar128in 
ml_qa_add_deliveryP@msgidvarchar128in 
ml_qa_add_deliveryP@addrvarchar255in 
ml_qa_add_deliveryP@clientvarchar128in 
ml_qa_add_deliveryP@statusinteger4in 
ml_qa_add_deliveryP@statustimetimestamp8in 
ml_qa_add_deliveryP@detailsvarchar1000in 
ml_qa_add_messageP@seqnobigint8in 
ml_qa_add_messageP@msgidvarchar128in 
ml_qa_add_messageP@origvarchar128in 
ml_qa_add_messageP@priorityinteger4in 
ml_qa_add_messageP@expirestimestamp8in 
ml_qa_add_messageP@propslong binary32767in 
ml_qa_add_messageP@kindinteger4in 
ml_qa_add_messageP@contentlong binary32767in 
ml_qa_add_messageP@contentsizeinteger4in 
ml_qa_handle_errorPactioninteger4in/out 
ml_qa_handle_errorPodbc_statevarchar5in 
ml_qa_handle_errorPerror_messagevarchar1000in 
ml_qa_handle_errorPuser_namevarchar128in 
ml_qa_handle_errorPtable_namevarchar128in 
ml_qa_stage_status_from_clientP@currUservarchar128in 
ml_qa_stage_status_from_clientP@tableNamevarchar128in 
ml_qa_staged_status_for_clientP@lastDwnldtimestamp8in 
ml_qa_staged_status_for_clientP@currUservarchar128in 
ml_qa_staged_status_for_clientP@tableNamevarchar128in 
ml_qa_upsert_global_propP@clientvarchar128in 
ml_qa_upsert_global_propP@namevarchar128in 
ml_qa_upsert_global_propP@modifiersinteger4in 
ml_qa_upsert_global_propP@valuelong varchar32767in 
ml_reset_sync_stateP@uservarchar128in 
ml_reset_sync_stateP@remote_idvarchar128in 
ml_server_deleteP@namevarchar128in 
ml_server_deleteP@livenessinteger4in 
ml_server_updateP@server_idinteger4in 
ml_server_updateP@livenessinteger4in 
ml_server_updateP@is_primaryinteger4in/out 
ml_server_updateP@fatal_errorinteger4in/out 
ml_set_deviceP@devicevarchar255in 
ml_set_deviceP@listener_versionvarchar128in 
ml_set_deviceP@listener_protocolinteger4in 
ml_set_deviceP@infovarchar255in 
ml_set_deviceP@ignore_trackingvarchar1in 
ml_set_deviceP@sourcevarchar255in 
ml_set_device_addressP@devicevarchar255in 
ml_set_device_addressP@mediumvarchar255in 
ml_set_device_addressP@addressvarchar255in 
ml_set_device_addressP@activevarchar1in 
ml_set_device_addressP@ignore_trackingvarchar1in 
ml_set_device_addressP@sourcevarchar255in 
ml_set_listeningP@namevarchar128in 
ml_set_listeningP@devicevarchar255in 
ml_set_listeningP@listeningvarchar1in 
ml_set_listeningP@ignore_trackingvarchar1in 
ml_set_listeningP@sourcevarchar255in 
ml_set_sis_sync_stateP@remote_idvarchar128in 
ml_set_sis_sync_stateP@subscription_idvarchar128in 
ml_set_sis_sync_stateP@publication_namevarchar128in 
ml_set_sis_sync_stateP@user_namevarchar128in 
ml_set_sis_sync_stateP@last_uploadtimestamp8in 
ml_set_sis_sync_stateP@last_downloadtimestamp8in 
ml_upload_update_device_addressP@addressvarchar255in 
ml_upload_update_device_addressP@activevarchar1in 
ml_upload_update_device_addressP@devicevarchar255in 
ml_upload_update_device_addressP@mediumvarchar255in 
ml_upload_update_listeningP@devicevarchar255in 
ml_upload_update_listeningP@listeningvarchar1in 
ml_upload_update_listeningP@namevarchar128in 
ml_qa_get_agent_network_propertyFNagentvarchar128in 
ml_qa_get_agent_network_propertyFNpnamevarchar128in 
ml_qa_get_agent_object_propertyFNagentvarchar128in 
ml_qa_get_agent_object_propertyFNobjnamevarchar128in 
ml_qa_get_agent_object_propertyFNpnamevarchar128in 
ml_qa_get_agent_propertyFNagentvarchar128in 
ml_qa_get_agent_propertyFNpnamevarchar128in 
ml_qa_get_message_propertyFNagentvarchar128in 
ml_qa_get_message_propertyFNpmsgidvarchar128in 
ml_qa_get_message_propertyFNpropnamevarchar128in 



Documentation generated by SqlSpec